MrExcel Publishing
Your One Stop for Excel Tips & Solutions

how to clear contents of all input cells at once


Posted by Jeff Stewart on October 14, 2001 7:41 AM

is thier a way to clear the contents of all input
cells or certin cells in a sheet? I am converting a old
lotus 123 file to EXCEL in the old lotus 123 thier was
a button to click on to clear certin input cells in the
file, i only want to clear them when needed not when i open the file. I dont know EXCEL verry well I am A
Beginer not much Knowlage at all.


Posted by Jim on October 14, 2001 11:51 AM

Hi Jeff,

Private Sub CommandButton1_Click()
Selection.Clear
End Sub

or if you have a range that will always be the same:

Private sub CommandButton1_Click
Application.ScreenUpdating =False
Range("A1:J10").Select
Selection.ClearContents
Range(A10:J10").Select
Selection.ClearContents
Application.ScreenUpdating = True
End Sub

Modify the Range as needed

HTH

Jim