Dim DataArray() As Double
ReDim DataArray(1 to iFinalCount)

Alan Beban

Jeff Harbin wrote:

I've got an range of cells of varying size made up of predominately doubles
with a few strings sprinkled amongst the doubles. I need to sort through the
array, determine the number of doubles in the array, and then populate an
array with the doubles.

I thought I could loop through the cells count the number of doubles, store
the number of doubles as a variable (iFinalCount), and then Dim an Array
using the iFinalCount variable like so...

Dim DataArray(1 to iFinalCount) as Double

When I try to run the code I get the following error:

Compile Error
Constant Expression required

If I hit Debug it takes me to the iFinalCount in the Array dimensioning
statement.

Btw...iFinalCount is defined as an integer

Thanks,

Jeff

Alan,

Can't e-mail you.
I might have a few interesting array functions for you.
Just let me know and I will mail them to you.

RBS


"Alan Beban" wrote in message
...
Dim DataArray() As Double
ReDim DataArray(1 to iFinalCount)

Alan Beban

Jeff Harbin wrote:

I've got an range of cells of varying size made up of predominately
doubles
with a few strings sprinkled amongst the doubles. I need to sort
through the
array, determine the number of doubles in the array, and then populate
an
array with the doubles.

I thought I could loop through the cells count the number of doubles,
store
the number of doubles as a variable (iFinalCount), and then Dim an Array
using the iFinalCount variable like so...

Dim DataArray(1 to iFinalCount) as Double

When I try to run the code I get the following error:

Compile Error
Constant Expression required

If I hit Debug it takes me to the iFinalCount in the Array dimensioning
statement.

Btw...iFinalCount is defined as an integer

Thanks,

Jeff

RB Smissaert wrote:
Alan,

Can't e-mail you.
I might have a few interesting array functions for you.
Just let me know and I will mail them to you.

RBS

Bart,

I've emailed you my email address. Is that what you meant?

Alan

Alan,

That is what I meant, but got it now.

Bart


"Alan Beban" wrote in message
...
RB Smissaert wrote:
Alan,

Can't e-mail you.
I might have a few interesting array functions for you.
Just let me know and I will mail them to you.

RBS

Bart,

I've emailed you my email address. Is that what you meant?

Alan