Use the Set keyword:
Set wagDetCell = wagNDCell
will mean that wagDetCell references the same cell as wagNDCell
--
Thanks

Simon


"Raman325" wrote:


Hi,

I have two cells in two different worksheets. One cell is referenced by
a range variable called wagNDCell. The second cell is referenced by a
different range variable called wagDetCell. I would like to link
wagDetCell to wagNDCell, so I tried wagDetCell.Formula = wagNDCell but
that didn't work because wagNDCell returns the value of the cell. How
do I create this link? Thanks in advance.

Raman


--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=396511