Modifying Relative Addressing
 

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.

Modifying Relative Addressing
 

Dale,

Insert your rows than use code similar to:

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

--
sb
"Dale Cox" wrote in message
...
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.