Posted to microsoft.public.excel.programming

Erik Mattsson Erik Mattsson is offline

external usenet poster

Posts: 1

Formula with indirect addressing

I have a workbook with 4 sheets in. "Total", "2007", "2008" and "2009".
On the "Total" sheet cell

B1 contains "2007" and
B3 contains "='2007'!E3"

I would like to have the formula in cell B3 dynamic in such a way that I
can change the cell B1 to "2008" and by that have the cell B3 show the
value in cell "='2007'!E3".

I have tried different types of "Indirect" by with no luck.

Please tell me how to code 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
Graphs using indirect addressing	[email protected]	Charts and Charting in Excel	3	January 2nd 08 05:37 PM
Indirect Addressing in VBA	C Brandt	Excel Discussion (Misc queries)	7	July 3rd 07 10:13 PM
Indirect Addressing	Kanga 85	Excel Discussion (Misc queries)	3	December 5th 05 04:03 AM
Indirect addressing	Ken Rock	Excel Programming	2	July 18th 05 01:29 PM
Indirect addressing	Tom Schroder	Excel Programming	1	November 3rd 03 08:11 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us