I tried to do that but it will not work in the actual cell reference.
I'm stumped.



humejap Wrote:
> Have you tried the formula
>
> =Concatenate("$J$",H1)
>
>
> --
> humejap
> ------------------------------------------------------------------------
> humejap's Profile:
> http://www.excelforum.com/member.php...fo&userid=5506
> View this thread:
> http://www.excelforum.com/showthread...hreadid=395098


--
jhockstr