Hi, Im really struggling here.

I have this piece of code that adds dates to my Outlook Calendar. If all dates are added at once, and the code is run then its fine, however staff need to input dates as and when. The code runs again and adds duplicate dates to outlook. Can anyone suggest a workaround that overwrites existing dates and only adds new ones.

I also found another problem. When A date is added ie 01/03/2016 it adds an entry to my calendar. However there are 484 rows and a calendar entry is added for all the blank rows as well, with a date of Sat 30/12/1899. How can I only add dates to the calendar and ignore at any blank cells.

Please Login or Register  to view this content.