View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Named ranges disappearing in Excel 2007

I have some named ranges (no more than 15) in a workbook and I am assigning
their values (in VBA) to string variables. For some reason my named ranges
are randomly disappearing after my code runs.

The syntax in VBA looks like this:

strDate = Worksheets("SheetName").Range("NamedRange1").Value

Any ideas?????