Excel VBA: How do you populate a range of 9 cells (a table) with values?

No replies
Fri, 12/11/2009 - 00:52
dana vlasceanu
User offline. Last seen 3 years 30 weeks ago. Offline
Joined: 10/26/2008
Posts: 11

Is it something like:
Range ("C15:E17").Value = Array (1, 2, 3; 4, 5, 6; 7, 8, 9)
I have a 3 x 3 array. So I will have 3 digits on each row, with 3 rows total. Not 9 digits on one row.

‹ Excel VBA: Selection object stuck in first iteration of for each loop, doesn't update? pacman in excel question? ›
Top