Hi all,
After inserting row I also need to paste Row # 2 (row above Row $ 3) after
copying the contents from one of the worksheets in the same file.

Request your help.

Thanks
P.Hamsa




"P.hamsa" wrote:

Hi,
I have an excel sheet with around 20 work sheets.
I want to insert one row above row no. 3, in each work sheet.
I do not want to do it manually as it takes time. Can anyone suggest on how
this can be done efficiently (either a VB Script or a macro)?

Thanks
P.Hamsa