Getting the name of highlithed cell

[Tim C]

Is there a way of getting the name of the highlight cell?

I want a cell to get the name of the highlighted cell.
Ex. if I was on C13 cell for instance (not in edit mode), I want let's say F3 to have C13 displayed on recalculation. If I changed the highlighted cell to C15 and recalculate, cell F3 would now show C13.
any ideas.. this maybe an easy one, but I;m not all the greatest in excel..

Thanx

Tim C

 

[Tim C]

Mudface you did it! Thanks for your help!!

 

[Mudface]

Tim, before you go, this is an improvement giving you the range if more than one cell is selected too:-
<pre>
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Range("F3").Value = Selection.Address(RowAbsolute:=False, ColumnAbsolute:=False)

End Sub
</pre>