Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
60
Views
Topic starter
The workbook currently sends an email when a task is a certain time away.
However, for this to happen I currently need to select the cells via an input box.
I want the cells to already be selected when I open up the document, so I don't have to select each time via the input box.
Help would be much appreciated - Workbook attached.
Posted : 07/11/2018 10:27 am
Hi Austin,
I don't know what range you want to select, but if you want to select A1:A2 you can use this in your Workbook_Open() sub to replace the InputBox
Set xRgDate = Range("A1:A2")
Regards
Phil
Posted : 07/11/2018 7:09 pm
