I have a sheet that i want to make a macro for. However i dont want the formulas to update to the new cell references when i insert new columns/rows. Ive tried locking the cells but the it still updates.
The other idea ive had is just add the formula editing to the macro. However this is a bit long winded.
Thanks in advance
Bookmarks