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