+ Reply to Thread
Results 1 to 2 of 2

Error while running my vba (error in copying of object)

  1. #1
    Forum Contributor
    Join Date
    11-06-2021
    Location
    Tripoli
    MS-Off Ver
    Still using 2007 in 2023
    Posts
    291

    Error while running my vba (error in copying of object)

    Hello guys,
    I hope you are all doing fine.
    I have been working a couple of days with my vba and everything was fine.
    Until a pop up error starts to pop up as follows:
    Run-time error '-2147417848 (80010108)':
    Method 'Copy of object'_Worksheet' Failed

    Also to not that excel was autorecovering files that werent saved throughout runing vba.

    Has my problem anything to do with my vba or it is something related to excel installed on my machine?

    Here is my code for reference...Thanks a lot.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2405-17628.20102
    Posts
    1,404

    Re: Error while running my vba (error in copying of object)

    Run-time error -2147417848 (80010108) Automation error.

    This error occurs on Microsoft Windows 95/98/2000 machines running Microsoft Word 2000 with full Microsoft Office installations. The issue is believed to result from international language support not being installed in the Microsoft Office installation.
    If things don't change they stay the same

+ 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. Object required Error in running the macro
    By bhartiya007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2020, 11:25 AM
  2. [SOLVED] Run-time error 91 when running a macro to modify an object property in a userform
    By Ghiran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-15-2019, 09:29 AM
  3. [SOLVED] Runtime error 1004 range of object with VBA code for copying all worksheets to word
    By vtcin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2014, 07:15 AM
  4. getting run time error 424 'object required' while running an sql query in VBA
    By basubdd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2013, 03:31 AM
  5. [SOLVED] Method 'Range' of object '_Global' failed error message on running userform when another
    By sivakumar123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2012, 11:39 AM
  6. Object error when running macro
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2012, 03:18 PM
  7. [SOLVED] Runtime Error '91': Object variable... When Running in Range Selection
    By Stonesteel15 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-01-2012, 09: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