200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hello,
I have just followed your tutorial https://www.youtube.com/watch?v=gIPdx4-rqGg and it has been super helpful, thank you!
What I did want to know is, if in the case of an error, how am I able to delete the cell containing the timestamp please as once I add an entry into the row, I would like the timestamp to be removed as well because currently the timestamp remains in the designated cell and I not able to delete it.
Thanks so much in advance!
Hi Abdul Q and welcome to the Forum.
Using the file associated with Don's tutorial, you should be able to simply delete incorrect timestamps in columns E and F (or copy/paste them from F to E), since the orginal code excluded them by the line:
'Your data table range
Set myTableRange = Range("A2:D50")Hope this fixes your problem. If so, please be sure to mark this Answer as Selected.
If not, please edit your question and use the Add Files... button to upload a representative Excel file (without any personal data) to show your existing macro and data. Then we should be able to give specific help.