Hi Richard

Try
ActiveCell.Value= cells(4,27).value

--

Regards
Roger Govier

"Richard" wrote in message
...
OS: MS XP
Excel 2003

I must use relative addressing and need to copy a formula from cell AA4 to
the relative address Im currently at. When I leave the relative address
to
copy the formula from cell AA4 I dont know how to get back to where I
need
to paste it. In other words I dont completely understand addressing in
VBA.
How can I read the address of the cell Im leaving and write the formula
back to that address?

Thanks in advanced.

--
Richard