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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named ranges disappearing in Excel 2007 2
Named Ranges - Multiple Worksheets 2
syntax to concatenate two named ranges? 2
Excel 2007 Named Ranges 0
automatically import multiple named-ranges from Excel to Access 2
Deleting all named ranges that have a workbook scope 3
Merging Multiple Named Ranges 5
Redundant Named Ranges Linking to Other Files 1

Top