Excel to outlook appointment date based on row selection question

Hello,

I was curious if the following code could be amended somehow so that the date range would be based on the row selected and then pull the date from column "D" of that same row selection? Ideally the user would select the row/date they want by selecting the row in column H. So if they selected cell H30 the appointment reminder would then populate in Outlook for the date in Column D, row 30, etc. Currently this code pulls in the date in cell S1 only. Any assistance would be greatly appreciated!

Please Login or Register  to view this content.