Can you share the macro?
whenever I see an error involving something "around" 33,000
I immediately look to integer variables.
do you have a line/loop counter? varible perhaps?
something like:
Dim rCount
or
Dim rCount as integer
??
integers are in the range -32768 to 32768
LONG integers:
can you share your file?
On Sat, May 31, 2014 at 2:57 AM, Bill Q wrote:
> Hi,
>
> I am using Excel 2010. I have a macro web query that downloads various
> information. It works fine. No issue there. The only issue that I have is
> that it will stop if it encounters more than 33 or 34 thousand r
