Effect of adding a column on a worksheet to all column refs in V

Hi Diane

You're quite right it is a common problem when amending spreadsheets with macro's attached.

Best practice emphases the importance of a change log, to keep track of changes and the impact they will have. This will help you quickly identify areas and take the appropriate steps when coding.

Additionally,identify something other than the column letter which will make it easier for Excel to find e.g. the Heading of the table "Employee Name" or "Invoice Amount" this way if the heading is moved Excel will still find it and move the relevant section.

Kind regards

Dennis