'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