I'm trying to work out how to create a formula that inserts a date stamp in column Y when any cells from column A to column W are edited in that row. I am aware of other discussions about how to do this for a single column, e.g. http://www.excelforum.com/excel-gene...=1#post2716586

but I haven't been able to work out how to modify this for a range of columns.

I'd prefer to use a formula because using VBA means I lose the Undo function.

Is anyone in a position to advise?

Thank you