Hi all, I'm Betty and I'm a VBA idiot....

First, I barely know what I am doing with this, and as it was several months ago I recall even less about of the details of what I did exactly. Our timesheets were changed/updated, mostly format changes. I made the changes based on the original VBA codes written a long time ago by another individual. It took a lot of trial and error but it seems to work...mostly. Before I get into why only mostly, here is how the timesheets are used:

1. Project hours are entered on “Sheet1”, the Worksheet.
2. Each Project HAS to be printed on a separate sheet unless there are multiple tasks for the same Project in which case they are all printed on the same sheet.
3. The Project to be printed is highlighted across (both rows per project).
4. Click on the “Print” button
5. The highlighted rows are copied over to the “Master” sheet and printed from there (to accommodated individual project printouts). and user is automatically returned to "Sheet1"
6. Each completed week’s sheet is saved as a new sheet

The first project to be printed gives a "run" error. Same thing happens when the worksheet is saved as a new week within the workbook. By the 2nd or 3rd try they work. There are also a few persons who have said that their OT (overtime) hours don't all show up. The OT problem may be operator error as I cannot duplicate the issue, but maybe not. I really, really, have only the most basic idea VBA.

I have attached screen shots that I hope can reveal the problem if any of you are willing to look it over.

Thank you