Is there an INDIRECT function for a RANGE?

[jmt]

I'm trying to find the equivalent of the INDIRECT function, but instead of a
cell location, I'd like to "build" a Range. As an example, I'd like to
convert the following text, "CONCATENATE("Sheet","'!A1:B4") to a range that
Excel can understand. If this were simply a cell reference, then the text
string could be the argument for the INDIRECT function. Is there a way to do
this? Thanks in advance

 

[T. Valko]

Not sure what you're looking for but it'll work as you describe.

D1 = text string: Sheet1!A1:B4

=SUM(INDIRECT(D1))

D1 = a formulated reference: ="Sheet1!A"&A1&":B"&B1

Where A1 and B1 contain the row numbers

=SUM(INDIRECT(D1))

 

[jmt]

Thank you. My error was omiting an apostrophe (') before th sheet name.

 

[T. Valko]

Thanks for feeding back!