View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MSE MSE is offline
external usenet poster
 
Posts: 15
Default Clear Contents Macro

I have a workbook with six worksheets. On Sheet 6, I want to create a macro
linked to an Excel button from the forms toolbar. I want the macro to only
clear the contents of Sheet 1, Sheet 2, Sheet 3, Sheet 4, and Sheet 5 in the
following cells C7, C9, C16:C23, and C26:C33. I am trying to write a code
that will do this, any thoughts?