Modifying Relative Addressing

[Dale Cox]

I need to copy, then insert 3 rows containing relative
addressing, but I need to retain the relative addressing
content as is, without modifying it (i.e., =Sheet1!A36
nees to remain the same). And I can't use absolute
addressing in the from addres.

 

[steve]

Dale,

Insert your rows than use code similar to:

Range("A15:M17").Formula = Range("A1:M3").Formula