+ Reply to Thread
Results 1 to 9 of 9

Error 1004 - Cells method failed

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    34

    Error 1004 - Cells method failed

    I´m getting the message posted in the title when I try to run this procedure:

    Please Login or Register  to view this content.
    What could it be?
    Tnx!

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Error 1004 - Cells method failed

    Hi, Marceltcm,

    if you refer to a sheet within a With-Statement be sure to add a dot before a range or cell.

    Maybe like this (i don´t see the reason for the k-Loop by now as it would return the same values to 6 Columns):
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Error 1004 - Cells method failed

    Try this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    08-29-2013
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Error 1004 - Cells method failed

    Indeed HaHo, you´ve already told me that and I am doing the same mistake, I will check that. Tnk u so much!

  5. #5
    Registered User
    Join Date
    08-29-2013
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Error 1004 - Cells method failed

    I tried both codes but now I´m receiving the error message: Runtime error 438, The object doesn´t accept this method or propertie

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Error 1004 - Cells method failed

    Works fine for me.

    Can you post the exact code you were using when you recieved that error?

  7. #7
    Registered User
    Join Date
    08-29-2013
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Error 1004 - Cells method failed

    Norie,
    Was the same that u posted to me.

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Error 1004 - Cells method failed

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  9. #9
    Registered User
    Join Date
    08-29-2013
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Error 1004 - Cells method failed

    Tnx Norie, sorry by my dumbness, but what means to desensitize data? My workbook has confidential information

+ 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. [SOLVED] Error 1004 Method Range of object_global failed
    By jamrock in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-12-2013, 10:58 AM
  2. Excel Macro Error - Run time error 1004 - Paste method of worksheet class failed
    By kvflynn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2012, 10:51 AM
  3. Delete method failed - error 1004
    By Marbles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2007, 07:47 AM
  4. Run time Error '1004: Method 'Cells' of object'_Global' failed
    By Ajay_N in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2006, 11:57 PM
  5. [SOLVED] Run-time error '1004': Method 'Cells' of object _Global failed
    By Fran D in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2006, 11:50 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