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