View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] pipenpaddleopsakopalus@yahoo.com is offline
external usenet poster
 
Posts: 1
Default how to make a macro to clear multiple cells from multiple worksheets?

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???