inserting rows on multiple worksheets
 

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

inserting rows on multiple worksheets
 

Katie,

Worksheets("Sheet2").Rows(ActiveCell.Row).EntireRo w.Insert

HTH,
Nikos

"katie" wrote in message
...
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