This one is tricky,

Each time I copy selected ROW.
I have to change this formula in various columns of row no. 259
=BDP($D$259,"interval_aVG","calc interval=30D","market data override=px_volume",G$204)
to
=BDP($D$270,"interval_aVG","calc interval=30D","market data override=px_volume",G$204)
for columns in row no. 270 and so on for other rows I copy the same formula.

This formula is used in column G,I,K (every alternate one) till column AA
Just to save the effort, I'm trying to figure out the macros I can use.


So far,

Sub copy()

Selection.copy
Range("A1000").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial (xlPasteAll)


End Sub

This one doesn't work for absolute ref. $D$270. This value has to remain absolute. So, I can't change it to D270. Need a macro.