Posted to microsoft.public.excel.programming

Zone[_3_]

external usenet poster

Posts: 373

Which Sheet Is Named Range On?

I have a workbook with several worksheets. Each worksheet has many
named ranges (single-cell ranges, all in row 1). I want to specify a
range name and have my subroutine activate the sheet containing the
range name and select the column containing the range name.
Thanks, James

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
Referencing a named range on another sheet	Jan B	Excel Worksheet Functions	5	April 4th 23 12:38 PM
Named range in a sheet referred to from another sheet	Lluis Escude	Excel Programming	2	June 28th 06 12:23 PM
Recalculate Named Range After Sheet Changes	soteman2005[_4_]	Excel Programming	0	December 5th 05 02:10 PM
Loop thru named range of second sheet	Bill Sturdevant[_2_]	Excel Programming	3	July 29th 05 07:15 PM
Referencing Named Range in Other Sheet	Dan E[_2_]	Excel Programming	0	July 11th 03 04:22 PM

All times are GMT +1. The time now is 09:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us