How can I delete a row from all worksheets in a workbook easily?

[Guest]

I have a workbbbo with 50+ worksheets. The worksheetsd are interactive. When
I delete a row from one, I get a #Ref error message on the others. Do I have
to open each worksheet and delete the same row ?
Is there a way to delete the same row on all worksheets with one command?

 

[Guest]

Hi

Group the sheets and delete the row:
Right click on a sheet tab and select Group Sheets.
Delete the row, and then right-click and Ungroup Sheets.
Make sure you take a backup before you start!

Andy.