Hi,

I have a worksheet where using VBA I am inserting a new row and setting cell values
in the new row to values specified in other worksheets. I can control the values I want to refer
to in this new row with my VBA code, but unfortunately the values in the rows below my insert
retain the same references, when I thought they would update by one row.

I.e cell B3 did contain ='Investment M&G'!D3

I insert a new row and set (new) B3 to the same ='Investment M&G'!D3

but I was hoping B4 would say ='Investment M&G'!D4 , but it says ='Investment M&G'!D3

Any clever worksheet function syntax I can use to stop this? If it helps the cells I
want to refer to in the other worksheet are always on the same row as the worksheet I'm working on