Indirect alternatives

B

Brad

Using XL 2007 with 2003 compatibility

The below equation works - but are there better alternatives>

=INDIRECT(Model_info!$E$25&"!R"&ROW()&"C"&COLUMN(),FALSE)
 
R

Roger Govier

Hi Brad

If in Model_info!E25 you enter something like Sheet3!$!:$65536, rather than
just a sheet name, then you can use

=INDEX(INDIRECT(Sheet2!$E$30),ROW(),COLUMN())
 
Top