Hi, tejastanna77,
Colored tabs where introduced with Excel2002/XP, not available in Excel2000.
Maybe you should work a bit on the code and avoid Select and Activate. Sample:
with something like
You set Objects (like shown above) that you do not use afterwards, you employ macro recorder based code which is reworked but could be made more efficient with just small work on it (which would reduce running time of the procedure as well as stability and even more readability of code). And maybe you should have a look at the Reddick Naming Conventions - I would not expect reP to be the object of a worksheet while wsRep would indicate that to me.
Ciao,
Holger
Bookmarks