View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default how to make a macro to clear multiple cells from multiple workshee

Your application is a poster child for using the Macro Recorder:

1. go to the first sheet
2. switch on the Recorder
3. carefully clear all the required cells in all the required sheets
4. switch off the Recorder

--
Gary''s Student - gsnu2007


" wrote:

i've got a protected document (can be unprotected if need be) in which
my employees fill out emission events daily. every day they must go
through every worksheet in the workbook to erase everything entered
the previous day. if they miss something it causes some reporting
errors. how can i create a macro which clears out the specific cells
i select from every worksheet in the workbook???