As an alternative, you could define a named range referring to the range on the other sheet. That should work in any version of Excel.

Regards, TMS