| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear the values, but not the formulas in a range
I'm trying to clear the values, but not the formulas in this range?
Range("E3:F3, E5:F5").ClearContents Is it possible? Cheers Aidy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear values but keep formulas? | Excel Discussion (Misc queries) | |||
| How do I clear data values wthout losing the formulas? | Excel Worksheet Functions | |||
| Automatically clear values from a range of selected cells | Excel Discussion (Misc queries) | |||
| Select range -- convert formulas to values | Excel Programming | |||
| How do I clear a worksheet of values, but leave formulas intact? | Excel Worksheet Functions | |||
Threaded Mode
