Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to copy absolute cells, then paste relative
I am trying to record a macro that will copy an absolute group of cells, then
paste relative to the cell that was active before running the macro. Can anyone help? Or maybe there is another way to accomplish my goal. I want to be able to insert a given set of cells in the middle of the document, any number of times. It is a form to be used over and over, but each time there will be a different number of these groups of cells in the form. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to copy absolute cells, then paste relative
Bill
maybe this will set you off in the right direction: Range("A1:E9").Copy ActiveCell Copies the range of cells to wherever the active cell is. Regards Trevor "Bill Carr" <Bill wrote in message ... I am trying to record a macro that will copy an absolute group of cells, then paste relative to the cell that was active before running the macro. Can anyone help? Or maybe there is another way to accomplish my goal. I want to be able to insert a given set of cells in the middle of the document, any number of times. It is a form to be used over and over, but each time there will be a different number of these groups of cells in the form. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Cant copy an relative Cell and make absolute | Excel Discussion (Misc queries) | |||
Absolute Values in Relative Cells | Excel Worksheet Functions | |||
How do I copy an absolute column and relative row to the right? | Excel Discussion (Misc queries) | |||
record macro - copy absolute, paste relative | Excel Programming | |||
missing macro absolute/relative referencing toolbar | Excel Programming |