| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearContents - Except NamedRanges
On Sheet1 I have 14 named ranges. Data is imported and placed around these
ranges so formulas within the ranges do calculations on the imported data. The named ranges will resize according to the amount of data imported, within certain known limits. I would like to be able to "reset" my sheet by clearing all cells that are not within a named range, so I can calculate the next imported dataset. Is this doable? Mike F |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting, pastevalues, clearcontents | Excel Discussion (Misc queries) | |||
| ClearContents Not Clearing Query | Excel Programming | |||
| Clearcontents | Excel Programming | |||
| Clearcontents | Excel Programming | |||
| Error of ClearContents | Excel Programming | |||
Threaded Mode
