Posted to microsoft.public.excel.worksheet.functions

Libby

external usenet poster

Posts: 151

Indirect function

I have the following formula to try and link to a cell in another workbook
but want to reference a new cell each day. I am getting a # ref. Can
somebody help with this please.

=INDIRECT("'"&$A$44&"'[mar MIR.xls]mid-city'!$g$39")
--
Libby

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
Indirect Function	Debbie Horner	Excel Worksheet Functions	1	December 27th 07 01:58 PM
Indirect function	andy	Excel Worksheet Functions	3	June 28th 07 07:40 AM
INDIRECT function	Tanya	Excel Worksheet Functions	2	May 17th 07 09:06 AM
Help with Indirect function ?	Richard Buttrey	Excel Worksheet Functions	4	May 24th 06 11:27 PM
Help with INDIRECT function.	DaveO	Excel Worksheet Functions	12	January 18th 06 09:52 AM

All times are GMT +1. The time now is 07:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us