I am trying to track all changes in a worksheet. Is there a formula to track the date and time for changes made to the entire worksheet in one specific cell? I know I can do a timestamp per row or column, but is there a way to do all changes go to one cell?
Try this.
Worksheet event forSheet1
Code
Right click on Sheet tab -->View code
Please Login or Register to view this content.
VB window opens
Paste the code.
Close window.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thank you so much! That is exactly what I was looking for!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks