Overflow Error

[DG]

I have a macro running agaist 40,000 line items and keep getting an overflow
error. I've seen this b/4 but can't remember how to fix it. Help?

Dan

 

[Jim Thomlinson]

You probably have an infinite loop somewhere... but without seeing your code
it is a little hard to tell. Post your code and we can take a look at it...

 

[Jim Cone]

Dan,

Change your row variable to a Long.
An Integer value cannot exceed 32,767

Jim Cone
San Francisco, USA

 

[DG]

Found it, you are correct.... Thanks

You probably have an infinite loop somewhere... but without seeing your code
it is a little hard to tell. Post your code and we can take a look at it...