Thread: Declaring Array
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Fredriksson via OfficeKB.com Fredriksson via OfficeKB.com is offline
external usenet poster
 
Posts: 51
Default Declaring Array

Thanks

merjet wrote:
Once I get my Array loaded. Is there a quick way to display the contents in
the array to verify that I loaded it correctly.


If it's 1-D or 2-D and you know its size, you can easily write it to a
worksheet, for example:

Sheets("Sheet1").Range("A1:C3") = myArray

If it's more than 2-D, it will take more work.

Hth,
Merjet


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1