=INDIRECT("D7")

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"rbmcclen" <rbmcclen.2b8wrf_1153401605.6255@excelforum-nospam.com> wrote in
message news:rbmcclen.2b8wrf_1153401605.6255@excelforum-nospam.com...
>
> Hi,
> How do I make excel continue to reference a cell location when the
> previous cell being referenced is deleted?
> If I have cell A1=B1 and delete B1 it changes A1 to be #REF!
> How do I make it continue to point to B1s location so that the new data
> that would fall into B1 is now referenced?
>
> Thanks in advance
>
>
> --
> rbmcclen
> ------------------------------------------------------------------------
> rbmcclen's Profile:
> http://www.excelforum.com/member.php...o&userid=36367
> View this thread: http://www.excelforum.com/showthread...hreadid=563279
>