JT,

Declare the array as a dynamic array, and then size it later in
code. E.g,

Public Arr() As Long

Sub AAA()
Dim N As Long
N = 100
ReDim Arr(1 To 3, 1 To N)
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"JT" wrote in message
...
I want to declare a 2 dimension public array but am having
trouble with the syntax because one of the dimensions
contains a variable.

This what I have so far:

Public MyArray (1 to 3, 1 to LastRow) but I get and error
message because it wants a constant instead of the
variable.

Can I do this? Any suggestions would be appreciated.
Thanks