VBA Code works in Excel 2003 but won't work in Excel 2000

Hi, everyone.

Thanks in advance for your help. I've got a very simple piece of code
written for Excel 2003 that crashes on a computer running Excel 2000,
and I can't figure out what the issue is for the life of me. Any
assistance would be greatly appreciated -- no need to rewrite the code;
just let me know what the offending piece is. The Excel 2000 user says
when he gets the run-time error and clicks debug, it drops him on the
Sub xxx() line.

Thanks.

Aaron

Please Login or Register  to view this content.

What's the error message? sounds like it might be a bad dim or compile error. refer to the error.

you have a type mismatch - redimension your CompetitorNum as a string.

Thanks.

I've set CompetitorNum as both an Integer and a String; doesn't make a difference either way.

It compiles & runs fine in Excel 2003, and the code doesn't have an Option Explicit, so it shouldn't be a Dim error.

I'll get the exact error message from the user and post it to see if you have any additional thoughts.

Thanks,

Aaron