+ Reply to Thread
Results 1 to 3 of 3

Runtime error 1004 when copying & pasting data to another sheet

  1. 04-17-2014, 03:54 PM #1
    luneke1
    luneke1 is offline
    Registered User
    Join Date
    04-09-2014
    Location
    Omaha
    MS-Off Ver
    Excel 2010
    Posts
    2

    Runtime error 1004 when copying & pasting data to another sheet

    Hello,

    I'm generating a runtime 1004 error with the macro I have attached to CommandButton1, "Clock_In".

    The macro is copying the name, date and time from 3 cells on Sheet1 and pasting special values to another sheet. Let me know if you think I can set this macro up better!

    Thanks in advance!
    Attached Files Attached Files
    Last edited by luneke1; 04-17-2014 at 03:57 PM.
    Reply With QuoteRegister To Reply
  2. 04-17-2014, 04:40 PM #2
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Runtime error 1004 when copying & pasting data to another sheet

    it seems to prefer you have the sheet object also....

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....
    Reply With QuoteRegister To Reply
  3. 04-17-2014, 06:04 PM #3
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Runtime error 1004 when copying & pasting data to another sheet

    Hi luneke1

    You ask
    Let me know if you think I can set this macro up better!
    Try this 
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Runtime 1004 Error when copying
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-03-2013, 09:51 AM
  2. Runtime Error 1004 while copying dinamic ranges
    By mallok in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-29-2013, 09:37 AM
  3. [SOLVED] Runtime Error 1004 when Copying worksheets from multiple workbooks into current workbook
    By dharris42 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 11:56 AM
  4. Copy and Pasting Issue (Runtime error '1004')
    By kinseld5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2013, 08:26 AM
  5. Runtime error 1004 when copying and pasting a filtered collumn excel 2010
    By Shedacq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2012, 06:35 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1