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

"DG" wrote:

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

Found it, you are correct.... Thanks


"Jim Thomlinson" wrote in message
...
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...

"DG" wrote:

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

Dan,

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

Jim Cone
San Francisco, USA


"DG" wrote in message
...
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