Excel 2003 Macro --> Excel 2000 Macro

Hi All,

I have a Macro which works just perfect in Excel 2003 or higher. But it is giving many kind of errors in Excel 2000.
I have commented many suspicious statements which may not work in older version still it is having problem.

It would be great help if anybody can suggest me code changes.
If you have Excel 2000 please try running it and solve the issues. I don't have Excel 2000

I have attached the whole macro. Code to be changed is Tejas_NewCode function in Module2.

Thanks in advance!