Simple Macro
 

I'm new at this, but I'm trying to create a macro with visual basic that
references an array. Can someone give me an example of this. The array is a
78 row, two column seperate s/s.

Simple Macro
 

Are you manipulating an array on the worksheet or are your creating an
array in VBA?

To create an array in VBA this is the dim statement

Dim MyArray( 1 to 78, 1 to 2) as Variant

to assign values

MyArray( 1, 1) = 45
' First row first column value is 45
MyArray( 1, 2) = Activesheet.Range("C2").value
' First row second column value is the value of cell C2

I do not know about manipulating worksheet arrays with code


OCONUS wrote:
I'm new at this, but I'm trying to create a macro with visual basic that
references an array. Can someone give me an example of this. The array is a
78 row, two column seperate s/s.