Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addressing in VBA
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addressing in VBA
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell addressing | Excel Worksheet Functions | |||
Cell addressing | Excel Worksheet Functions | |||
Cell addressing | Excel Worksheet Functions | |||
Relative addressing | Excel Worksheet Functions | |||
two D addressing? lookup? | Excel Discussion (Misc queries) |