Thanks for the solution in posts #2 and #4 which works. However posted the query since I am interested in this due to curiosity and academic interest (learning) since it worries me what seems to work while recording macro doesn't work the same way while running the macro. Moreover, if it works, this is easier for me to perform it by recording macro rather than by writing script.