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

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?

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

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.

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