View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BRC[_2_] BRC[_2_] is offline
external usenet poster
 
Posts: 19
Default deleting named ranges on a worksheet (not workbook)

Hi All
I am writhing a routine that takes a data set that is pasted in and
then does several calculations. in the process it defines several
ranges. I would like to have a line of code (or subroutine)that would
delete any named ranges in the worksheet to make certian we are
starting with clean sheet. Any help is appreciated. Thanks BRC