Results 1 to 16 of 16

RunTime Error 2147417848 -Method insert of object Range Failed

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2014
    Location
    Mauritius
    MS-Off Ver
    2013
    Posts
    50

    RunTime Error 2147417848 -Method insert of object Range Failed

    Hi,
    When running below Code in my excel sheet , Error message >> Run time error 214741848 (80010108) >> Method "Insert" of object "Range" failed.
    Please help

    Sub Copy_Insert_Row_nTime()
    Dim x As Integer
      x = Application.InputBox("INSERT NUMBER", "INSERT NUMBER", Type:=1)
      If x = False Then Exit Sub
        ActiveCell.EntireRow.Copy
        Range(ActiveCell.Offset(1), ActiveCell.Offset(x)).EntireRow.Insert
        Application.CutCopyMode = False
    End Sub
    Last edited by JBeaucaire; 07-11-2016 at 04:52 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Run-time error -2147417848 (80010108) Method Value of object Range failed
    By Arito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2015, 02:10 PM
  2. Runtime Error 2147417848(80010108) Method Autofill of Object Range failed
    By seejohn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2014, 08:03 AM
  3. "Runtime error '-2147417848 (80010108)' Method 'find' of object 'Range' failed"
    By excelworker_1 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-14-2012, 09:53 AM
  4. Runtime Error 1004 Method 'Range of Object'_Global' failed
    By popfan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2011, 12:52 AM
  5. Runtime error .. 20028018: Method value of object range failed
    By petca059 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2010, 04:40 AM
  6. 1004:runtime error method 'range' of object'_Global failed
    By trksbc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2009, 03:25 AM
  7. [SOLVED] runtime error 1004 method range of object '_global failed
    By valdesd in forum Excel General
    Replies: 2
    Last Post: 10-06-2005, 03:05 PM

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