Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
relative ref. macro
Recording macros can get you only so far, unfortunately...
Assume you want to copy the selected cell(s) five rows down. One way is: Public Sub Copy5RowsDown() With Selection .Copy Destination:=.Offset(5, 0) End With End Sub In article , "Milton" wrote: I want to copy several cells to new locations in the same spreadsheet, using a macro in relative mode. When I click on the Relative Reference Button on the Stop Recording Toolbar the button shows as "relative" only as long as the cursor is pointing to it. Then when I do the copy/paste function only the first copy is relative and all following copy/paste events are absolete. Also the relative function works for only one cell, if several cells are selected the copy is absolute mode even if the relative reference button was pressed. Any help will be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Relative Macro | Excel Discussion (Misc queries) | |||
Macro using relative references | Excel Worksheet Functions | |||
How to macro to relative position | Excel Discussion (Misc queries) | |||
relative value in macro | Excel Discussion (Misc queries) | |||
macro relative referencing | Excel Discussion (Misc queries) |