Excel, read in an array

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

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

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?




"Rowan" wrote:

> 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
>

Rowan used:
dim myArray as Variant

Did you change that?

If you did, change it back.

AustinJames wrote:
>
> 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?
>
> "Rowan" wrote:
>
> > 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
> >

--

Dave Peterson

Got it. Thanks

"Dave Peterson" wrote:

> Rowan used:
> dim myArray as Variant
>
> Did you change that?
>
> If you did, change it back.
>
> AustinJames wrote:
> >
> > 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?
> >
> > "Rowan" wrote:
> >
> > > 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
> > >
>
> --
>
> Dave Peterson
>