Posted to microsoft.public.excel.worksheet.functions

thanks

external usenet poster

Posts: 48

INDIRECT Help

Hello
I am having trouble with an INDIRECT formula. My formula on sheet qtr 1:
INDIRECT("INDEX(Myrange"&RIGHT(SHEETNAME,1)&",1,"& COLUMN()+1&")")
refering to named range MyRange1. This formula returns #value!. When I
step through the formula the sheetname returns 2 but if I put the formula
sheetname() in a cell byitslef it returns 1. I do have a range named
MyRange2 but yet it doent even return a wrong answer.
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
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions	Mike Barlow	Excel Worksheet Functions	7	May 21st 23 07:42 PM
Use of 'INDIRECT	LN	Excel Worksheet Functions	1	June 18th 08 04:27 PM
INDIRECT.EXT	[email protected]	Excel Worksheet Functions	3	April 11th 08 04:13 AM
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4)	Dave F[_2_]	Excel Discussion (Misc queries)	3	September 20th 07 08:36 PM
INDIRECT.EXT	Danny Lewis	Excel Worksheet Functions	0	July 14th 06 11:00 AM

All times are GMT +1. The time now is 10:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us