Here's the table. You'll note that there are two tiny, empty cells in it that didn't carry over when I copied it here. Those are days I don't work, so they were empty on the schedule.

The output might not depend on which day is the first day of the week, (and I have my default first day of the week to be Sunday) but I want to be sure you know when you help me design the macro to make the first day in the table equal Saturday in the iCalendar file.

I want the event title and calendar to be "work," the alarm to be "1 day," and location be the difference of the two "M" values, equaling either "1 hour" or "30 minutes."

Thanks.

Attached Files

Macro.doc (25.0 KB, 10 views)