View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Derick[_2_] Derick[_2_] is offline
external usenet poster
 
Posts: 1
Default Refer to Elements in an array

I have a dynamic array whcih would be redimed to hold
values in 20 rows and four columns TestArray(1 to 20, 4)

How can I refer to the array so that the contents of a row
in the array be sent to the worksheet.
For example Range("A1:D1") = TestArray(1,4)

Derick