Excel Vba Can A Vba Function Return A Range

[Solved] Excel Vba Can A Vba Function Return A Range | Vb - Code Explorer | yomemimo.com
Question : excel vba can a vba function return a range?

Answered by : daniel-ferry

'VBA functions can return an Excel range, but since a range
'is an object, the 'Set' keyword is required:
Function Test() As Range Set Test = [A1:Z99]
End Function

Source : http://academy.excelhero.com/ | Last Update : Sat, 09 May 20

Answers related to excel vba can a vba function return a range

Code Explorer Popular Question For Vb