Carolyn Hurley

How do you debug?

Sheets("Calendar").Activate                                                                     'Activate the Calendar sheet
   calRowNum = Application.WorksheetFunction.Match(CLng(actionDate), weekRange, 0)                 'Set the calRownum as the row number of the matching date in col A of the calendar sheet