View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
unhide all columns[_2_] unhide all columns[_2_] is offline
external usenet poster
 
Posts: 5
Default clear inputs macro

THis macro seems to be clearing all items from the sheet
I only need it to clear the rows i have listed
Sub clear_inputs_new()
'
' clear_inputs Macro
'
ActiveWindow.ScrollRow = 1
Range("I11:I114").Select
Selection.ClearContents
Range("AD11:AD114").Select
Selection.ClearContents
End Sub