Thread: Deleted Reference Cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Deleted Reference Cell
=INDIRECT("D7")

--
Don Guillett
SalesAid Software

"rbmcclen" wrote in
message ...

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



Reply With QuoteReply With Quote