Indirect alternative

[Brad]

Using Excel 2007 (with compatibility with 2003)

Currently using the following function (a multitude of times)

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

Where Model_info!$E$25 - will be different sheet names.

What alternatives do I have?

 

[Rasoul Khoshravan]

Using Excel 2007 (with compatibility with 2003)

Currently using the following function (a multitude of times)

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

Where Model_info!$E$25 - will be different sheet names.

What alternatives do I have?

Indirect function has two variables, first one is reference text in
your case Model_info!$E$25
and second one is a logical value (true, false).
What is the &"!R"&ROW()&"C"&COLUMN() phrase in your command?
If you want to concatenate, you have to use
INDIRECT(Model_info!$E$25,FALSE)&"!R"&ROW()&"C"&COLUMN()

 

[Shane Devenshire]

Hi,

Why don't you tell us what it is you want your formula to do. And why the
current formula does not meet your needs?