Hi, a macro in my sheet does not automatically update when a new column is added in another sheet. The sample code is:

Range("E200").Value = ThisWorkbook.Sheets("DCF").Range("AT5")

If I add new column in sheet DCF, then the original cell AT5 will become AT6. But the macro is still AT5.

Do you know how to make the macro change automatically?