Hi John,

Thank you for the reply, although I don't think that's my problem. The name
Model_RTable_StatusMsg is a global name (i.e. in the names collection of the
workbook), and its definition includes the sheet specifier. If I query the
address of Model_RTable_StatusMsg on a sheet other than the Power Model
sheet, I get 'Power Model'!$AF$6 as expected.

And I have other cases where I'm successfully referencing names mapped to
one worksheet from other worksheets.

Any other ideas? ;)

Wolf

"John" wrote:

I think you need the sheet name in the code if its not being called from the
active worksheet
E.g (untested)
setRngCell = worksheets("Test").range("Data")

HTH
J