hi,

Am Wed, 6 Jan 2016 00:27:42 +0000 (UTC) schrieb tb:

The hope was that this would produce in P7 a formula (i.e. =A7).
Instead it creates a string, i.e. "=A7".

you could do it with:
=INDIRECT("A"&AL7)
But I would prefer Garry's VBA solution.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional