Still going with this, I have fixed most of my poor referencing but I'm stuck on this one.
How can I change the column reference 'S' to a named range, its part of a table.
I'd like to change this as if i add columns to the left, it throws off the references in other VBA code.


Sheets("Customers").Range("S" & ActiveCell.Row) = Date