View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KIM W KIM W is offline
external usenet poster
 
Posts: 52
Default Check if Range EXISTS

How can I verify if a range exists on a worksheet?
I am looping through all worksheets retrieving worksheet name info from a
range, but I don't want to include worksheets without the specified named
range. THe same name is used on each worksheet with scope limikted to the
worksheet.