You don't need to write any code. Just turn on the macro recorder and perform
the steps manually. Stop the recorder. Then whenever you want to do the same
again, run the macro you recorded.

"GoBow777" wrote:


Please read the my query on the attachment.


+-------------------------------------------------------------------+
|Filename: GoBow777.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=117|
+-------------------------------------------------------------------+



--
GoBow777