Thread: Reset Button
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 Reset Button

Place the button on your sheet and assign this macro to it:

Sub raz()
Range("B8:T9").Clear
Range("B11:T51").Clear
End Sub
--
Gary''s Student - gsnu200816


"Raz" wrote:

Please help how to create and use macro codes for a Button. (never used macro
before)

need a button in cell T4 and
need these cells (below) to reset to blank when button clicked

B8 to T8
B9 to T9
B11 to T11
B12 to T12
B14 to T14
B15 to T15
B17 to T18
...........
..........
B51 to T51


Thanks