Will it do any harm to the computer if I ignore the Overflow issue in Excel 2002

Hi all,

I got a windows Xp laptop and MS Excel 2002 installed. The excel file has more than 33000 rows of data.
Recently when I ran a simple macro to filter for specific data, an error popped up warning:

Please Login or Register  to view this content.

I deleted some of the rows to 30000 now, but the error still happened.
I googled for some help and some people suggested me using this code:

Please Login or Register  to view this content.

And then the error never appeared again.

But I am not sure if this will do any harm to my computer if I used this code.

Please help if you could.

Thanks
Kitty

Kiity,
This error hides the problem, but does not solve the underlaying problem. You need to loop through the code using F8-stepping over and find out the error.

Originally Posted by AB33

Kiity,
This error hides the problem, but does not solve the underlaying problem. You need to loop through the code using F8-stepping over and find out the error.

Thanks for the quick help.

When I pressed F8, a yellow bar highlighting some lines in the code, does this mean there are errors in the codes?

Yes, there are!
On resume next skipps the error lines and you assume the code is working.

Originally Posted by Norie

Kitty

Can you post the code?

Here is the code, Norie.
I am still fixing the errors....

Please Login or Register  to view this content.