Is there dynamic code?

  • Hello,

    In the table, when I insert into any cell value =A1, for example, whenever I change the A1 position the code of another cell is also changed to the new position of A1. Ok, everyone knows, dynamic reference... However, references to A1 in VBA source code is not changed. There is dynamic code too?


  • No. There is no dynamic code. VBA is an addition to Excel many years after Excel was first released so the code and the worksheet are 2 entirely separate things.

    The nearest you can get is named ranges. As you add/delete row or columns, the VBA reference to the named range will always refer to the correct cell.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!