Search code examples
excelvbaexcel-formulaexcel-indirect

Move a highly referenced cell without having to fix the reference everywhere

I have a start date that I reference in about 140 difference cells in all sorts of places on my worksheet (not just one column or row). This start date is at the bottom of my worksheet and I want to move it to the top without having to change the references everywhere.

How can I do this?

Solution

  • For the sake of an answer:

    Just drag it to where you would prefer but beware of functions such as OFFSET and INDIRECT.