I have written code to send a reminder to Outlook via Excel
I get run time error and the following code is highlighted
Please advise on how to correctPlease Login or Register to view this content.
I have written code to send a reminder to Outlook via Excel
I get run time error and the following code is highlighted
Please advise on how to correctPlease Login or Register to view this content.
I have not looked at you file but what comes to mind is that the timestamp in the cell you are referring is incorrect and not recognized.
Have you checked that value?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
It works on my Laptop, so not sure why it is not working on my PC
This works fine for me.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
If it works on one and not the other, I suggest you check your date and time settings if they are identical, it must be something small like that
Thanks for the amended code Bakerman2-it works perfectly
Thanks for your input. it most probably something to do with Time & Date settings
The code provided by Bakerman2 works perfectly
Your welcome.
If this answers your question please mark the thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks