Can somebody remind me the syntax to declare arrays in Excel modules?

What i need to do:

Declare an array, but size unknown. Thus, programmatically I need to expand
the size.

"DKS" wrote:

Can somebody remind me the syntax to declare arrays in Excel modules?

Dim MyIntegerArray() As Integer

Use ReDim to define it at runtime
"DKS" wrote:

What i need to do:

Declare an array, but size unknown. Thus, programmatically I need to expand
the size.

"DKS" wrote:

Can somebody remind me the syntax to declare arrays in Excel modules?

Thanks Suhas. That is exactly what I was trying to remember.

"Suhas" wrote:

Dim MyIntegerArray() As Integer

Use ReDim to define it at runtime
"DKS" wrote:

What i need to do:

Declare an array, but size unknown. Thus, programmatically I need to expand
the size.

"DKS" wrote:

Can somebody remind me the syntax to declare arrays in Excel modules?

You need to use a Dynamic Array; that is, an array whose bounds are not
specified in the Dim statement but rather set at run-time with the Redim
function. For example,

Dim Arr() As String
Dim N As Long

N = SomeValue
Redim Arr(1 to N)

If you use Redim on an existing array, the contents of the array are
destroyed unless you use the Preserve modifer:

Redim Preserve Arr(1 To N)



--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

"DKS" wrote in message
...
What i need to do:

Declare an array, but size unknown. Thus, programmatically I need to
expand
the size.

"DKS" wrote:

Can somebody remind me the syntax to declare arrays in Excel modules?