WeslyWest

How do i create an array that has a different number of values everytime it is used. I have a variable called TotalNumber that defines the length of the array but cannot put it in the dim statement, any help, thanks.

Thinker

Start by declaring a dynamic array with...
Dim myarray() As Long 'or whatever type you need

Then when you are ready to size it, use...
ReDim myarray(TotalNumber) 'might want to use TotalNumber - 1

Ronq

To do that you have to use redim, if you want to get it bigger or smaller but don't loose the data in the array you have to use redim preserve. For example like this:


You may also want to look in the help for:
Ubound
Lbound

Bye.
Ronq.

Mikecrosoft

use ReDim

You need to Dim there:

Dim YourArray() as Long

Then whe you need change the array size do this:

ReDim YourArray(NewSize)

if you don't need erase the content of the array use Preserve:

Redim Preserve YourArray(NewSize)

Preserve only use to change the first dim of the array, this mean, you can't Redim Preserve this:

Redim Preserve (12,NewValue) as long

but you can Redim Preserve this:

Redim Preserve (NewSize,12) as Long



I hope help !!

NateBrei

I thought it was the other way around. I thought you could only ReDim the LAST dimension.

Nate

Thinker

You are correct Nate. Only the last one.