Using sheetname variable in a formula

M

mms

No that didn't work... but got me to experiment...

' ' A-325 ' works
(<single quote>, <single quote>, <A-325>, <single quote>)

Thank you very much!!

Do you know WHY this works, because than maybe I can alter somethin
else in the INDIRECT call, as I'm sure the users of this sheet wil
balk at having to enter 3 single quotes in addition to the A-325 etc.

Please understand, I am not complaining about your solution, as I a
delighted I got it working at all.

Thanks again!
 
Top