+ Reply to Thread
Results 1 to 5 of 5

Unexplained VBA error (1004)

  1. #1
    Registered User
    Join Date
    03-14-2016
    Location
    Germany
    MS-Off Ver
    Office 2013
    Posts
    15

    Angry Unexplained VBA error (1004)

    Hi guys, my code looks as follows:
    Please Login or Register  to view this content.
    For some reason (a similar macro is running in other sheets I use) this code is not working. When I try to debug, the bold marked line is highlighted. I don't know whats wrong with this. Any ideas?

    Thank you in advance.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Unexplained VBA error (1004)

    Other problems with the code aside, you can't copy an entire row to column D. The copied range is three cells wider than can be pasted.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-14-2016
    Location
    Germany
    MS-Off Ver
    Office 2013
    Posts
    15

    Re: Unexplained VBA error (1004)

    shg, that was the problem...fixed it with Range("....").Select

    Thank you!

  4. #4
    Registered User
    Join Date
    03-14-2016
    Location
    Germany
    MS-Off Ver
    Office 2013
    Posts
    15

    Re: Unexplained VBA error (1004)

    shg, that was the problem...fixed it with Range("....").Select

    Thank you!

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Unexplained VBA error (1004)

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Runtime error '1004': Paste special method of range class error.
    By Daryl Zer0 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-05-2014, 01:44 AM
  2. [SOLVED] Sort Macro Run-time error '1004': Application/Object-defined error.
    By sam1212 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2014, 10:05 AM
  3. [SOLVED] VBA Error: Runtime Error 1004: AutoFilter method of Range class failed
    By jl22stac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2013, 07:27 PM
  4. [SOLVED] Getting Error 1004 Object or Application Defined Error - Code to rearrange data
    By BlazzedTroll in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-10-2013, 12:10 PM
  5. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM
  6. Error 75 File/Path access error, sometimes Error 1004
    By smokebreak in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-16-2011, 02:35 PM
  7. [SOLVED] Unexplained "Bad Record Length" error / bug?
    By Dave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2006, 11:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1