Niek,
OP confirmed that your suggestion works.
Last post was in relation to using the range names themselves in a formula.
To rllane47,
Suggest that you rename some of your ranges and retry using the names
*without* the necessity of incorporating them in an Indirect formula.
=Tom Joe
For example works on all the three platforms and versions that I tested.
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------
It is not clear to me what you tried, what did work and what didn't.
I tested my answer:
----------
=INDIRECT(Q5) INDIRECT(T3)
Space after (Q5)
-----------
Did you?
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
