Hi

This may be simply down to the settings on my computer, but if I insert new
cells to a worksheet which results in certain cells reference changing (eg if
I insert a new column A, then all the cells previously in column A are now in
column B) my macros do not update the reference, which means when I do
anything like that I have to manually go through the macro and change all the
references which is very time consuming and irritating.

Is there a simple setting I can change to avoid this?

Thanks

Phil