| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste cells with reference
I am trying to programitically copy a group of cells that contain a
formula into another group of cells, i want the copied cells to keep there reference when they are pasted. please note that i cant use $ signs since i am doing this programitically. thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste cells with reference
Hello,
Did you try the following: ' let's say Range("A1:A20") is the set of cells with the formula you want ' and Range("D10:D18") is the set of cells to copy to. Range("D10:D18").FormulaR1C1 = Range("A1:A20").FormulaR1C1 The FormulaR1C1 property preserves the relative locations. Chad " wrote: I am trying to programitically copy a group of cells that contain a formula into another group of cells, i want the copied cells to keep there reference when they are pasted. please note that i cant use $ signs since i am doing this programitically. thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| Paste Linking with Absolute Reference | Excel Discussion (Misc queries) | |||
| Cut and paste by reference part 2 | Excel Programming | |||
| Cut and paste by reference | Excel Programming | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
Linear Mode
