Hi, Mukesh,

what do you really want to achieve? Me to rewrite every bit of code that you have gathered from the Forum so far?

You mentioned the given cell but that cell will hold the date after the code is run. So it might be possible to adapt the original macro to your needs but I doubt this should be part of me participating or be part of this thread.

Ciao,
Holger