May 03 2021 05:33 PM
May 04 2021 03:26 AM - edited May 04 2021 03:27 AM
When you click one of the buttons, it changes the value of cell B3 on the Schedule sheet.
This causes the Worksheet_Change event procedure to run, and this calls ScheduleRefresh.
The ScheduleRefresh macro has a loop For WeekCol = 5 To 23 Step 3 ... Next WeekCol.
The second time through this loop, WeekCol equals 8.
The code adds a new sheet, and tries to rename it to the value of Cells(110, WeekCol). But Cells(110, 8),
Perhaps some of these steps shouldn't occur - can you explain?
May 04 2021 06:43 AM
This excel program was downloaded from Excel freelancers website and I really like how it works. I really don't know why this happens and I try to find the root cause of it. If there anything in vba code that doesn't need to be there, can you suggest any changes to it that will as normal? Thanks.