+ Reply to Thread
Results 1 to 4 of 4

recording macros in Excel 2013, run-time error `1004`

  1. #1
    Registered User
    Join Date
    02-27-2015
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    18

    recording macros in Excel 2013, run-time error `1004`

    Hello All,
    I have a workbook that contains worksheets of the same structure and I need to update them monthly with new data.
    I used to record macros in Excel 2010 and then run them on the other worksheets with the same structure as the one I recorded the macro on. I am trying to do the same in Excel 2013 but I have issues with it, I get run-time error `1004` (select method of Range class failed). When I click on debug, it highlights the following part: Range("Table1016242934384261222[@Column19]").Select
    (Full code is below.)
    I have never had this issue in Excel 2010, actually I can`t even remember seeing these long table names consisting of numbers in the codes in Excel 2010.
    I also seem to have issues with the relative references in my code.
    What could be the problem?
    Cheers

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor dlow's Avatar
    Join Date
    08-12-2013
    Location
    EveryWhere
    MS-Off Ver
    Excel 2007, 2010
    Posts
    275

    Re: recording macros in Excel 2013, run-time error `1004`

    Hi,

    Have you seen this KB & tried those solutions?

    HTH

    Thats the extent of my ability to help, Somebody with more skill & knowledge will be along shortly to help you out.

    Oh one last thing I think that there is a section on the forum for chart help & stuff, maybe the people who could help you might be lurking there.
    Last edited by dlow; 03-15-2015 at 09:45 PM.

  3. #3
    Registered User
    Join Date
    02-27-2015
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    18

    Re: recording macros in Excel 2013, run-time error `1004`

    Hi dlow,
    Yes, I do have charts linked to the tables I am trying to update with the code...so I guess I should look for the solution around those charts.
    Thanks

  4. #4
    Forum Contributor dlow's Avatar
    Join Date
    08-12-2013
    Location
    EveryWhere
    MS-Off Ver
    Excel 2007, 2010
    Posts
    275

    Re: recording macros in Excel 2013, run-time error `1004`

    Thanks for the Rep point

+ 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. VBA ERROR: run time error 1004: Application-defined or Object-defined error in excel 2013
    By AnanthKrishna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2015, 06:16 AM
  2. MACRO ERROR WITH EXCEL 2013 - Run-Time Error '-2147417848 (80010108)'
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2014, 11:07 AM
  3. Recording Macro to create a Pivot Table in Excel 2013: run time error 5 invalid procedure
    By developerstew in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2013, 07:17 AM
  4. Need help fixing macros due to Run-Time error 1004 Sort Reference is Not Valid
    By travisg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2013, 12:13 AM
  5. Replies: 1
    Last Post: 05-05-2010, 01:33 PM

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