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!

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!