Posted to microsoft.public.excel.programming

Mike

external usenet poster

Posts: 3,101

Named ranges disappearing in Excel 2007

I have some named ranges (no more than 15) in a workbook and I am assigning
their values 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?????

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 Named Ranges	Barb Reinhardt	Excel Discussion (Misc queries)	0	September 22nd 08 08:01 PM
Named Ranges Disappearing in Excel 2007	Mike H.	Excel Discussion (Misc queries)	6	April 29th 08 05:36 PM
Named ranges disappearing in Excel 2007	Mike	Excel Discussion (Misc queries)	0	December 18th 07 08:09 PM
Named ranges in Excel 2007	[email protected]	Excel Discussion (Misc queries)	2	September 10th 07 08:22 PM
Excel 2007 Beta-Named Ranges	reno	Excel Discussion (Misc queries)	4	June 26th 06 09:33 PM

All times are GMT +1. The time now is 12:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us