Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lloyd Alvarez   on Sep 07 In MS Office Category.

Clear Button in excel spreadsheet


  
Question Answered By: Myron James   on Sep 07

Sub ClearButton1_Click()
Dim cell  As Range

Range("E5:E12").Select
For Each cell In Selection
If cell.Locked = False Then cell.ClearContents
Next
Range("G3").Activate
Selection.ClearContents
End Sub

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Clear Button in excel spreadsheet Or get search suggestion and latest updates.


Tagged: