Forum Discussion
Date of Last Modified for a Cell
Good day, all. I am inquiring if there is an excel function that would give me a date (and time) that an individual cell was last modified. For example: cell A2 has an entry of $2.55 and I'd lik...
Thanks, that worked. Only problem I'm having is that I can't insert rows as it says the limit is exceeded. I'll only ever need 200 rows or so. Can I limit it to 200 rows instead of the million?
That must have another cause. The code doesn't impose a limit.
- Yeah I think the problem was when I inserted a column. It then put the last edit time in all rows to the end. Should be good now. Thanks again!
Did you perhaps do something that caused the code to enter the date and time in ALL rows of column K? If so, do the following:
- Activate the Visual Basic Editor.
- Press Ctrl+G to activate the Immediate window.
- Type (or copy/paste) the line Application.EnableEvents = False
- With the insertion point in that line, press Enter.
- Switch back to Excel.
- Select all rows from the row below the "real" used range of the sheet to the very last row 1048576.
- Right-click in the selection and select Delete.
- Activate the Visual Basic Editor.
- Press Ctrl+G to activate the Immediate window.
- Type (or copy/paste) the line Application.EnableEvents = True
- With the insertion point in that line, press Enter.
- Switch back to Excel.
- Save the workbook.
HansVogelaar Did this screenshot work? It's the error message I get