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