The result is that you end up tracking only those changes done by users, not changes done by macros. With event handling turned off, the Worksheet_Change event handler won't be triggered and the 'last changed' address won't be updated. For instance, the following EnableEvents property change could be used before and after a command that changes the contents of cell A1: You then could use a regular macro to retrieve the address stored in the sAddr variable and do whatever you want with it.Īs for making sure that the event handler doesn't record any changes done by macros, the only way to do this is to turn off event handling before executing any macro command that will modify the worksheet. You could modify the macro so that it maintained the address in a global variable (declared outside of the event handler) in this manner: The macro simply puts the address of the last change into the status bar. Private Sub Worksheet_Change(ByVal Target As Range) I added another set of parentheses to each A2. I tried to change it but it would not work. so the timestamp updates when any one of that range of cells is modified. This formula uses the CELL function to get the reference of the last edited cell. To learn more about the workbook object model, read Work with workbooks using the Excel JavaScript API. If you have to insert the date and timestamp in a few cells in Excel.

Workbook is the top level object which contains related workbook objects such as worksheets, tables, and ranges. A macro that does this could be rather simple, such as this one: Excel.Workbook class - Office Add-ins Microsoft Docs. You can use the Worksheet_Change event to write a handler that will record when any particular cell in a worksheet is changed. If the shape was modified in an earlier version of Excel.

He doesn't want to know if the cell was changed by a macro, but specifically by a user. 6 KB) To find the last used row in a column, this technique starts at the last cell in the. John wonders if there is a way in VBA to identify the last cell that was changed by a user.

Excel date cell last modified