How to save contents of cell range in an array?
Hi John,
I would use a dynamic array, so it's easy when you have to change your range.
dim aNumbers() as long
dim lNumber as long
dim lCol as long
dim lRow as long
For lRow = 1 to 12
For lCol = 1 to 12
Redim Preserve aNumbers(lRow - 1, lCol -1)
aNumbers(lRow - 1, lCol - 1 = Cells(lRow, lCol).value
Next
Next
"John Uebersax" wrote:
In a VBA subroutine, how can one, for example, save the contents
(numbers) of the range A1:L12 in the array x(12,12)?
And how does one declare x()?
Thanks in advance.
John Uebersax
.
|