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

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

[Jim Cone]

Dan,

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

Jim Cone
San Francisco, USA


"DG" <nothere@somewhere.com> wrote in message
news:OFQZOfdQFHA.2972@TK2MSFTNGP14.phx.gbl...
> 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
>
>

[DG]

Found it, you are correct.... Thanks


"Jim Thomlinson" <JimThomlinson@discussions.microsoft.com> wrote in message
news:424E98D6-1979-4DDF-8BF9-020846244692@microsoft.com...
> 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
> >
> >
> >