Thanks Anne. You have been very helpful.
Dori

"FinRazel" wrote:

Yes, this method will work on multiple worksheets. Simply make all of your
selections for one worksheet, hit delete, then move on to the next worksheet.
When you are finished deleting the final worksheet, stop recording your
macro.

Cheers!
--
Anne Murray


"DORI" wrote:

Thank you so much FinRazel. I followed your instructions and it worked. My
only question is if this works only for the active worksheet. It would be
great if I could apply this to the entire workbook to clear multiple
worksheets with one click.
Dori