View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default 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