runtime error '6' overflow

I get a runtime error in a routine that has run many times in the
past.
The difference is each month I have more data.
the routine does a sort then stops at this line:

finalrow=cells(rows.count,"a").end(xlup).row

The answer should be 41236.
If I comment out this line and simply put in

finalrow=41236

I still get the runtime error '6'

If I put this line in a temp subroutine is runs fine.

Not sure what to do next.

Thanks for any help.

Don

dim finalrow as long not as integer.




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


don wrote :

> I get a runtime error in a routine that has run many times in the
> past.
> The difference is each month I have more data.
> the routine does a sort then stops at this line:
>
> finalrow=cells(rows.count,"a").end(xlup).row
>
> The answer should be 41236.
> If I comment out this line and simply put in
>
> finalrow=41236
>
> I still get the runtime error '6'
>
> If I put this line in a temp subroutine is runs fine.
>
> Not sure what to do next.
>
> Thanks for any help.
>
> Don

Don,
How have you DIMmed "finalrow" ? As an Integer ?

NickHK

"don" <[email protected]> wrote in message
news:[email protected]...
> I get a runtime error in a routine that has run many times in the
> past.
> The difference is each month I have more data.
> the routine does a sort then stops at this line:
>
> finalrow=cells(rows.count,"a").end(xlup).row
>
> The answer should be 41236.
> If I comment out this line and simply put in
>
> finalrow=41236
>
> I still get the runtime error '6'
>
> If I put this line in a temp subroutine is runs fine.
>
> Not sure what to do next.
>
> Thanks for any help.
>
> Don

yes, I dimensioned it as an integer.
I guess it needs to be dim as long

Don

On Tue, 26 Jul 2005 09:35:38 +0800, "NickHK" <[email protected]>
wrote:

>Don,
>How have you DIMmed "finalrow" ? As an Integer ?
>
>NickHK
>
>"don" <[email protected]> wrote in message
>news:[email protected]...
>> I get a runtime error in a routine that has run many times in the
>> past.
>> The difference is each month I have more data.
>> the routine does a sort then stops at this line:
>>
>> finalrow=cells(rows.count,"a").end(xlup).row
>>
>> The answer should be 41236.
>> If I comment out this line and simply put in
>>
>> finalrow=41236
>>
>> I still get the runtime error '6'
>>
>> If I put this line in a temp subroutine is runs fine.
>>
>> Not sure what to do next.
>>
>> Thanks for any help.
>>
>> Don
>