The below code copies a range from the “Staffing Plan” sheet to the “Resource HourCost” sheet.
It performs correctly when the “Staffing Plan” sheet is active but not when the “Resource HoursCost” sheet is active.
I have tried ActiveWorkbook as well as ThisWorkbook with the same result.
What...