Creating a timestamp for changes made across a range of cells in a row

[mariam15]

Hi!

I want to track changes I have made on my worksheet by having a time stamp against each row. I have data from columns C to AX. I would like to have a timestamp in Column AY (only date would also work), if any value changes in any cell between C and AX.

I found a couple of VBA codes which work for changes made in one cell, but I could not tweak them for a range of cells.

I'm a complete novice in writing vba code, so any help would be great!

Thanks!

 

[0rtli]

As this is a significantly different question, it needs a new thread. Thanks

Done

Creating timestamp if cell range changes

Hi guys, So I need some help solving the issues. I have data range from A2:Q and if in this range cell is empty R also should be empty, if A2:Q were filled with something, I would like to have a timestamp in column R. Besides this, data in A2:Q can be copy&pasted so I found an old thread where...

www.mrexcel.com