Thread: Named cells in an array to a column and to a row
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
  
Posts: 852
Default Named cells in an array to a column and to a row
On Wednesday, February 19, 2014 11:40:34 AM UTC-8, GS wrote:
To explain Claus' solution.., a 1D array will transfer to a worksheet

as '1 row x n cols' by default, and so to get it to transfer as 'n rows

x 1 col' you need to transpose it.



You will only get the number of elements that fit into the resize. If

the resize is larger than the array then the extra cells display #N/A.



--

Garry


Thanks Claus for the snippet and thank you Garry for 'splainin it.

Regards,
Howard
Reply With QuoteReply With Quote