+ Reply to Thread
Results 1 to 5 of 5

receiving the 1004 error code.

  1. #1
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    191

    receiving the 1004 error code.

    I am receiving the 1004 error code.
    For wkb_main.Sheets("Index").Select
    While using the following code:

    Please Login or Register  to view this content.


    I’m not sure where my mistake is any help will be appreciated.

  2. #2
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: receiving the 1004 error code.

    is there an "Index" sheet in ThisWorkbook ?
    can you debug it a bit with
    Please Login or Register  to view this content.
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  3. #3
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: receiving the 1004 error code.

    The answer is yes to both questions.
    Any other ideas?

  4. #4
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: receiving the 1004 error code.

    have you tried to put a ThisWorkbook.Activate before the wkb_main.Sheets("Index").Select ?

  5. #5
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: receiving the 1004 error code.

    That seems to work thank you
    Now I am receiving error Invalid procedure call or argument
    for Set SourceFolder = FSO.GetFolder(Path_All_36_Still_Photos)
    That seems to work thank you
    Now I am receiving error Invalid procedure call or argument
    for Set SourceFolder = FSO.GetFolder(Path_All_36_Still_Photos)

    Do you have any idea how to solve that one
    ?

+ 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. Receiving runtime error 1004
    By Adriandiaz101 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2015, 05:36 PM
  2. [SOLVED] Keep receiving Run-time error '1004': Application-defined or object-defined error
    By BladeAP in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2014, 04:24 PM
  3. [SOLVED] I'm receiving a Run-Time error 1004 while trying to delete a product from a product list.
    By redsab in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2014, 10:03 PM
  4. How to use RANGE Statment - Receiving Error 1004
    By efisher in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 01-13-2014, 01:14 PM
  5. [SOLVED] Receiving Runtime Error 1004 -Cannot Access file
    By Dean Staples in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-30-2013, 09:27 PM
  6. [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
  7. Receiving runtime error 1004: Method 'Range' of object '_Worksheet' failed
    By DrShocktopus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2010, 10:39 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