Results 1 to 3 of 3

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

Threaded View

  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:
    Sub CUTPASTE()
        Dim rngSource As Range, rngDestination As Range
        
        Set rngSource = ActiveCell.EntireRow
        
        On Error Resume Next
        Set rngDestination = Application.InputBox("The active cell's entire row will be cut. " & vbLf & _
                                                  "Select the destination cell to insert the cut row.", _
                                                  "Move Row", Type:=8)
        On Error GoTo 0
        
        If rngDestination Is Nothing Then Exit Sub 'User canceled
        
        ActiveSheet.Unprotect Password:="p@ssw0rd!"
            rngSource.Cut
            rngDestination.EntireRow.INSERT Shift:=xlDown
        ActiveSheet.Protect Password:="p@ssw0rd!", AllowFormattingCells:=True
    End Sub
    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

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