??? Using variables in Sheet names within formulas???

[ectoid]

This one's been bugging me for a long time...

I've got a column of this formula for 100+ rows:
IF(MAX(ShtName!$F$7:$F$66)=blaa blaa blaa

The ShtName! changes for each row in the column of formulas.

Instead of manually rewriting the formula for each sheet, I'd like to call the name as a cell variable such that I can copy and paste the range with relative cell values.

Is it possible to call a cell variable as a SheetName! in a formula?

Thanks,
-Eric

 

[JPM]

Well you could use the indirect method, as in =IF(MAX(INDIRECT(D3))=bla bla bla, where D3 would contain 'Sheet2'!F2:F24.

JPM

 

[ectoid]

YEAHHHHH....IT WORKS!!!
WOW...that all I can say...
Thanks so so much...

 

[JPM]

Glad to help