You can group the sheets by CTRL + click on sheet tabs.

On active sheet select the range to delete and hit delete button.

All grouped sheets will have that range deleted.

You may want to select all cells on the active sheet and F5SpecialConstants

This will leave formulas intact.

DO NOT FORGET to ungroup the sheets when done this operation.


Gord Dibben MS Excel MVP

On Thu, 2 Aug 2007 11:44:03 -0700, MarcelMarceau
wrote:

Is there a way to delete the data input area of several worksheets at the
same time using a macro maybe?