| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to clear checkboxes and protected cells | Excel Worksheet Functions | |||
| clear cells macro | Excel Discussion (Misc queries) | |||
| macro to clear cells | Excel Discussion (Misc queries) | |||
| Moving from unlocked cells to unlocked cells in an excel form | Excel Worksheet Functions | |||
| Macro to clear cells | Excel Discussion (Misc queries) | |||
Threaded Mode
