+ Reply to Thread
Results 1 to 5 of 5

ClearContents method of Range class failed

  1. #1
    Registered User
    Join Date
    09-26-2019
    Location
    San Diego CA
    MS-Off Ver
    Office 365
    Posts
    4

    Question ClearContents method of Range class failed

    I have a template that I have been using for years. It seems after at work we were upgraded to Windows 10 I get several intermittent errors when I run certain macros on my template.

    I get "Run-time error '1004': ClearContents method of Range class failed" when I use the macro to delete the contents in the template. It always worked before now it periodically won't.

    This is the macro: When I click debug the 5th line in the macro where it says "Selection.ClearContents" is shaded yellow.
    Please Login or Register  to view this content.
    I also get Run-time error '-2147417848 (80010108) Automation error The object has disconnected from its clients. This happens when I am running a macro that does text to columns. Like the previous one it always worked before and now periodically I get this error message.

    Here is the macro:
    Please Login or Register  to view this content.
    The only work around is that I have to close the template, close Excel and open it again. This is rather annoying. I am not a techie or anything but I would like to know why this is happening and how to correct it. All of my other templates work fine.

    I have looked up why this could be happening and I can't find anything that matches my situation on any forums that could help me.

    Thanks
    Last edited by Paul; 09-26-2019 at 05:28 PM. Reason: Added CODE tags for new user. Please do so yourself in the future.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: ClearContents method of Range class failed

    Part 1:
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-26-2019
    Location
    San Diego CA
    MS-Off Ver
    Office 365
    Posts
    4

    Re: ClearContents method of Range class failed

    Thanks for your help. Is there anyone that can help me with the second part of my post regarding the Run-time error '-2147417848 (80010108) Automation error The object has disconnected from its clients that happens when I am running a macro that does text to columns.

    Thanks,
    Linda

  4. #4
    Registered User
    Join Date
    09-26-2019
    Location
    San Diego CA
    MS-Off Ver
    Office 365
    Posts
    4

    Re: ClearContents method of Range class failed

    Sorry I tried to delete this post but I am not able.
    Last edited by DuchessCornFlake; 10-29-2019 at 07:23 PM.

  5. #5
    Registered User
    Join Date
    09-26-2019
    Location
    San Diego CA
    MS-Off Ver
    Office 365
    Posts
    4

    Re: ClearContents method of Range class failed

    Quote Originally Posted by protonLeah View Post
    Part 1:
    Please Login or Register  to view this content.
    I am still getting the ClearContents method of Range class failed error even though I changed the code to the one suggested.

+ 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. Select method of Range class failed
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 03:12 PM
  2. cut method of range class failed
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2012, 12:48 PM
  3. Select Method of Range Class Failed
    By Screamtruth in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-07-2010, 07:01 AM
  4. search method of range class failed
    By sarahng86 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2007, 04:23 AM
  5. Select Method of range class failed
    By excel_rookie74 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2006, 12:17 PM
  6. PasteSpecial method of Range class failed
    By windsor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-06-2005, 06:05 PM
  7. What did I do? (Select Method of Range Class Failed )
    By HotRod in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-20-2005, 10:06 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