Can you do a similar video using Visual Basic to put todays date/time whenever a range of cells is modified, the current date/time can be showed in a cell at the top of the page? I was trying to figure out how to edit the code you used in this example, but cannot figure it out. I dont want the date/time at the end of each individual row, I just want it at the top of the worksheet (we have 1450 items, and simply want to see if ANY changes are made to the worksheet with a quick look to one spot :) Thanks in advance. Love your videos!
@HeyKimmi Thank you for your suggestion. But, you can just modify the range statement as the following one to get that result. Range("H1") = Now() Would love to know if it's worked out for you. Thanks again for reaching out.
Can you do a similar video using Visual Basic to put todays date/time whenever a range of cells is modified, the current date/time can be showed in a cell at the top of the page? I was trying to figure out how to edit the code you used in this example, but cannot figure it out. I dont want the date/time at the end of each individual row, I just want it at the top of the worksheet (we have 1450 items, and simply want to see if ANY changes are made to the worksheet with a quick look to one spot :) Thanks in advance. Love your videos!
@HeyKimmi Thank you for your suggestion. But, you can just modify the range statement as the following one to get that result.
Range("H1") = Now()
Would love to know if it's worked out for you. Thanks again for reaching out.