Results 1 to 6 of 6

Macro to copy a line to archive sheet and delete from active sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-18-2012
    Location
    Chicopee, Ma
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    199

    Macro to copy a line to archive sheet and delete from active sheet

    My attached spread sheet has a macro that copies the line highlighted to the archive sheet and then deletes that line from the active sheet the macro is activated by hitting the button at the top left of any of the department sheets.
    The macro worked fine until the end of our fiscal year when I removed all the archived work orders from the archive page, to start the year new.
    Now when I try to archive something from one of the department sheets, it copies it to archive and gives me a range error.
    Up until now there has always been information on the archive sheet, I'm not sure if removing all the information on that sheet caused the macro to stop working properly.

    Could someone please look at the macro set up and tell me if I am doing something wrong?

    I'd be happy to send the last working file upon request. (the file that has all the information in the archive section and was running the macro correctly)

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to select sheet and copy data from one sheet to another on new line every time
    By goatie43 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2015, 07:26 AM
  2. [SOLVED] VBA - Macro issue copy/paste line other sheet + duplicate current sheet
    By vcourbiere in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-17-2014, 12:06 PM
  3. [SOLVED] Need a macro to copy dates & data from one sheet to an updating archive sheet
    By pbj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2013, 06:58 PM
  4. Replies: 1
    Last Post: 01-07-2013, 12:23 AM
  5. Delete Rows that contains zero and Copy active sheet to New Sheet
    By antoni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2009, 02:02 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