I hope I understand, you will get this address using

ActiveCell.Address

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"7redmetal" wrote in message
...
I want to be able to change the cell reference within a macro which is in a
given cell based on where the cursor is. In short I want this cell
reference
to reflect the cursor's position much like is done in the upper left of
the
spread sheet.