Closed Thread
Results 1 to 2 of 2

Timesheet Printing & Saving gives "run" error and OT not always copying over

  1. #1
    Registered User
    Join Date
    07-14-2016
    Location
    Pittsburgh, PA
    MS-Off Ver
    2010
    Posts
    10

    Timesheet Printing & Saving gives "run" error and OT not always copying over

    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).
    6. Each completed week’s sheet is saved as a new sheet

    The first time/project to be printed gives a "run" error. Same thing happens when the worksheet is saved and a new week within the workbook. 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
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Timesheet Printing & Saving gives "run" error and OT not always copying over

    Hi, welcome to the forum

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.

    https://www.excelforum.com/excel-pro...ying-over.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 09-13-2016, 01:31 PM
  2. Problem at saving sencond file in a loop "Run time error '9'"
    By tuxo99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2016, 05:40 AM
  3. Replies: 35
    Last Post: 01-13-2016, 02:16 AM
  4. Script not copying data from "Emails" sheet to "New Sheet" - Run time error: Object
    By methuselah90 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2014, 03:22 PM
  5. Error on saving: ActiveX listbox "does not support saving"
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2012, 06:54 PM
  6. Replies: 0
    Last Post: 06-22-2012, 01:38 AM
  7. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1