View Single Post
  #2   Report Post  
Rowan
 
Posts: n/a
Default

Maybe this would work for you:

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

Hope this helps
Rowan

AustinJames wrote:
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