| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing Values in a Range under certain conditions
I'd like to clear values from myRange under either of the following conditions
If the cell doesn't contain a formula OR if the cell is locked. I have the following CODE For Each r In myRange Debug.Print r.Row, r.Formula, r.locked If r.Formula = No Then r.ClearContents End If Next r I see that r.formula returns No when there is a formula and r.locked returns True or False. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clearing all values in range that aren't formulas | Excel Programming | |||
| Clearing the Values in a Drop - Down List | Excel Discussion (Misc queries) | |||
| Clearing the Values in a Drop - Down List | Excel Programming | |||
| Clearing Form Values the easy Way??? | Excel Programming | |||
| vba clearing out values stored in array | Excel Programming | |||
Threaded Mode
