Macro Run Time error - Invalid procedure call or argument

I am trying to figure out why my macro won't work completely. When I reun this, I get a Run-Time error "5" - Invalid procedure call or argument. The first sheet6 changes for the "A" cells but not the B's and sheet 8 & 9 go unchanged. The 17 is referring to the number letters in the workbook name ScheduleTablet!B - Debug highlights Cell.Formula = Left(Cell.Formula, 17) & Right(Cell.Formula, Len(Cell.Formula) - 17) + 21 for sheet6

Please Login or Register  to view this content.