Overflow Error

  • Thread starter Thread starter DG
  • Start date Start date
D

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
 
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...
 
Dan,

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

Jim Cone
San Francisco, USA
 
Found it, you are correct.... Thanks


Jim Thomlinson said:
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...
Click to expand...
 
Back
Top