View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default declaring a public array

Hi
as you can't use a variable in thie declaration statement try something
different. e.g.

public MyArray()

'...other global declarations

Public Sub Initialize()
Dim lastrow

lastrow = 10
ReDim MyArray(1 to 3, 1 to lastrow)
'...
end sub


--
Regards
Frank Kabel
Frankfurt, Germany


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