Run time error after running macro

[Navneet]

I am getting run time error after saving SAVE or opening the excel sheet.

Macro is running at the time of saving or opening file.

Please find the attached file.


thanks

Navy

[pike]

Hi Navneet,
place the code in a module not in the worksheet
replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

you will have a problem with this lin

Please Login or Register  to view this content.

as the dat formats dont match

[snb]

I'd prefer to put all this in the 'Thisworkbook' module:

Please Login or Register  to view this content.