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" <(E-Mail Removed)> wrote in message
news:54164EBE-5AE2-4136-9665-(E-Mail Removed)...
> 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?