Addressing in VBA

R

Richard

OS: MS XP
Excel 2003

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

Thanks in advanced.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup for cells with text in them 4
Button macro to move/delete active row 4
grouping Radio Buttons; Using ActiveX Controls 2
Some columns don't change when I sort 1
Using Cartesian Cell Names 1
automating use of complicated formula 4
Highlight changes within cell 1
Using clips in Excel 3

Top