View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] westcoasthockeyleague@gmail.com is offline
external usenet poster
 
Posts: 1
Default Write 3d array to range

Hi,

I have an array defined as:
Dim team_vs_team_array(15, 15, 5)

Through code I populate each value within the array reading from
various worksheets, and completing calculations along the way (each
value is an integer).
Through the Watch function in VBA, I can confirm that the array is
holding the data the way I expect.

How can I accomplish the following:
Worksheets("temp").range("c4:ct19") = team_vs_team_array


I have been reading he archived messages, and thus far have not been
able to come up with a solution that fits my problem.

I am working in XL2003.

thanks in advance.