Sorry. You were using the worksheet's index, I just substituted with a sheet's codename for testing, but forgot to take it out. To fix:Originally Posted by mduff
MarkWith ThisWorkbook.Worksheets(1)
Sorry. You were using the worksheet's index, I just substituted with a sheet's codename for testing, but forgot to take it out. To fix:Originally Posted by mduff
MarkWith ThisWorkbook.Worksheets(1)