Excel, read in an array

[AustinJames]

Hey all -

I've got an array in my worksheet with values that can and probably will
change.

I'm writing a macro to read it into an array. Then once there I can perform
calculations. Its at 15x15 array. I just can't figure out how to bring the
data into the array! I can bump through the rows, i just can't figure out
how to iterate through the columns. Or is there a better way to do it?

Thanks in advance

 

[Rowan]

Maybe this would work for you:

Dim myArray As Variant
myArray = Range("A1:O15").Value

Hope this helps
Rowan

 

[AustinJames]

When I try that i get an error:

Can't assign to array.

So i guess you can't assign the .Value property to an array. Thanks for the
idea. Any others?

 

[Dave Peterson]

Rowan used:
dim myArray as Variant

Did you change that?

If you did, change it back.

 

[AustinJames]

Got it. Thanks

Rowan used:
dim myArray as Variant

Did you change that?

If you did, change it back.