Posted to microsoft.public.excel.programming

Gary Keramidas Gary Keramidas is offline

external usenet poster

Posts: 2,494

range name question

i'll simplify a little here. i have a separate workbook with rates and some
named ranges. let's say one is Joe_Tier1 and another is Bob_Tier1.

then bob and joe have separate workbooks.

if i have their name in A1. how would i write a formula to replace "Joe" wit the
value in A1?

Rates.xls!Joe_Tier1*G58

--

Gary

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
Range question in '97	Adam Kroger	Excel Discussion (Misc queries)	10	December 12th 05 03:44 AM
Range Question / error 1004: method Range of object Worksheet has failed	Paul	Excel Programming	3	April 7th 05 02:56 PM
Range question	mnewnam[_2_]	Excel Programming	0	October 28th 04 07:28 PM
Range question	Lee dengo	Excel Programming	2	May 25th 04 09:41 PM
Range.Formula and Range question using Excel Automation	[email protected]	Excel Programming	0	September 19th 03 04:53 AM

All times are GMT +1. The time now is 03:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us