inserting rows on multiple worksheets

K

katie

Hi
This piece of code inserts a new row on the current
worksheet, above the active cell.
Anyone know how this can be expanded to insert a new row
in exactly the same position on worksheet 2?
Many Thanks
katie
 
N

Nikos Yannacopoulos

Katie,

Worksheets("Sheet2").Rows(ActiveCell.Row).EntireRow.Insert

HTH,
Nikos
 
Top