Modifying Relative Addressing

  • Thread starter Thread starter Dale Cox
  • Start date Start date
D

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.
 
Dale,

Insert your rows than use code similar to:

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