keep formula working when changing fprmula in source cell

[curious4]

I have a formula in cell a1 referencing to cell D3, which contains a formula too.

Now I have a vba running that copies a cell containing a formula to D3. The result is that cell A1 gives an error.

Is there a way to make the formula in cell a1 still working ?

[TMS]

Try using PasteSpecial with formula (and formatting) rather than copying and (just) pasting the cell.

[rajansettu]

Hi,

Try using address() function to refer the cell d1 in a1 if it dosnt work kindly attach a sample sheet.

[rajansettu]

hi,


Try this in cell a1 [=INDIRECT(ADDRESS(3,4))]