VBA Overflow Run-Time Error

[Exceller12]

Hello Everybody,

I am receiving a run-time error for overflow when I run a macro that I have created. I have input cells for numbers that need to accept up to a trillion. However, when I enter 1,000,000,000,000, it will throw an overflow error. There are several places that I use a similar line of code, but the Debug takes me to the below line of code first.

If Worksheets(1).Cells(lRow, 41).value <> 0 Then

If there are any suggestions, it would be greatly appreciated.


Thanks a trillion in advance.

 

[mikerickson]

Is lRow, an integer?

 

[NdNoviceHlp]

trial...

If Worksheets(1).Cells(lRow, 41).value <> vbnullstring Then

or perhaps there is an error in the cell? HTH. Dave
ps. 1 trillion cells?

 

[Exceller12]

Thank you both for the assistance. Just to clarify some things. lRow is data type long and it is used to loop through rows. If I enter 1 trillion, the error occurs.

I have attempted to use vbnullstring in my code and the error is still occurring. I also need to save the contents of the cells to a variable. Do you know of a way to save 1 trillion in a variable, such as:
Var = Worksheets(1).Cells(lRow, 41).value

 

[NdNoviceHlp]

lrow is number of rows... there can't be a trillion rows. Use data type double or variant to hold large numbers. Dave

 

[Exceller12]

Just to clarify. I am not looking for one trillion rows. For instance, my issue is if $1 trillion dollars is entered into a cell, then the error occurrs.