Named ranges disappearing in Excel 2007

M

Mike

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?????
 
Top