Posted to microsoft.public.excel.programming

Michael Monteiro Michael Monteiro is offline

external usenet poster

Posts: 3

Accessing Named Ranges

Can I access a named range defined on sheet1 from sheet2?
I have a loop that iterates though Application.Names and I
can see the named range I am interested in. However, I
cannot access it via Range(Application.Names("foo")). I
get an exception when I do. Is this expected behavior? Any
way around this?

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
named ranges	Carol Ann	Excel Worksheet Functions	4	February 4th 08 05:20 PM
Named Ranges	diaare	Excel Worksheet Functions	0	August 24th 07 04:16 PM
Named Ranges - accessing a cell	mojoweiss	Excel Discussion (Misc queries)	1	September 1st 05 04:20 PM
Accessing named ranges in Excel from VBA	Basz	Excel Discussion (Misc queries)	1	August 10th 05 03:21 PM
Like 123, allow named ranges, and print named ranges	WP	Excel Discussion (Misc queries)	1	April 8th 05 06:07 PM

All times are GMT +1. The time now is 07:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us