Thread: Named range in an array
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Named range in an array
No, there is no requirement to use WorksheetFunction. No typo.

--
Regards,
Tom Ogilvy


"ccroche" wrote in message
...
Sorry, I think there is again a typo ...

If you want a 1D array
v = application.WorkSheetFunction.Transpose(Range("xyz "))

Christian CROCHE


Reply With QuoteReply With Quote