+ Reply to Thread
Results 1 to 3 of 3

MACRO ERROR WITH EXCEL 2013 - Run-Time Error '-2147417848 (80010108)'

  1. #1
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    MACRO ERROR WITH EXCEL 2013 - Run-Time Error '-2147417848 (80010108)'

    Hello,

    I have problem with the attached file when I use Microsoft excel 2013. In fact, with Microsoft Excel 2010 I have no problem at all.

    pwd: p@ssw0rd!

    The error is the following one:
    Run-Time Error '-2147417848 (80010108)': Method error'Insert' of object 'Range'

    The macro I use is:
    Please Login or Register  to view this content.
    Can you please help me figuring out why it does work?

    I also have problem with the Sub COPYPASTE() macro which doesn't work in Excel 2010. But that would be a plus for me I do not want to mix problem.

    PS: CTRL + X = cut macro and CTRL + C = copy macro

    Many thanks in advance,
    Graig
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: MACRO ERROR WITH EXCEL 2013 - Run-Time Error '-2147417848 (80010108)'

    Mine worked fine, active cell was a4, selected a15 for pasting, all ok.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    Re: MACRO ERROR WITH EXCEL 2013 - Run-Time Error '-2147417848 (80010108)'

    Thanks. In fact I need to test the row from 8:35 (table range is: B8:O35)

+ 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. Excel 2010 - Intermittent Run Time Error -2147417848 (80010108)
    By PatKlaus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-30-2013, 02:46 PM
  2. Replies: 7
    Last Post: 05-15-2013, 09:02 AM
  3. Run-time error '-2147417848 (80010108)': Automation error
    By Lightboxes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2012, 05:53 PM
  4. macro and userforms crash and give Run-time error '-2147417848 (80010108)'
    By gryffin13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2012, 02:16 PM
  5. Replies: 7
    Last Post: 08-24-2005, 11:05 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