View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CandiC CandiC is offline
external usenet poster
 
Posts: 37
Default clear unlocked cells macro help please

I have the following macro attached to a button on my "Price Estimator"
worksheet trying to clear contents in all of the unlocked cells of the
worksheet. Can someone please help me figure out what is wrong with the
following:

Sub ClearForm()
Dim c As Range
For Each c In Sheets("PRICE ESTIMATOR").UsedRange
If c.Locked = False Then
c.ClearContents
End Sub