+ Reply to Thread
Results 1 to 2 of 2

Error in Excel VBA code for inserting combo box - "Insert method of Range Class failed"

  1. #1
    Registered User
    Join Date
    04-01-2014
    Location
    Pune, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Unhappy Error in Excel VBA code for inserting combo box - "Insert method of Range Class failed"

    Hi
    I have created an excel code in which when a button is pressed, it inserts a row and two combo boxes. it works fine when the button is pressed a couple of times but after pressing the button 3-4 times (inserting 3-4 rows), I get the error - "Run time error '1004': Insert method of Range class failed". I am unable to find any work around based upon alternatives suggested in this forum. Please can any one go through this code and set me on the correct path. Following is my code -
    ----------------------------------------------------------------------------------------------------------------
    Please Login or Register  to view this content.
    --------------------------------------------------------------------------------------

    Also there is a weird problem, the excel crashes very often when I use this sheet. Also the error points to the following line of code -

    Cells(endRow + 1, "A").EntireRow.Insert

    Many thanks,
    -Aditya
    Last edited by adityam; 04-01-2014 at 03:20 AM.

  2. #2
    Registered User
    Join Date
    04-01-2014
    Location
    Pune, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Error in Excel VBA code for inserting combo box - "Insert method of Range Class failed

    Thanks for the reminder, I have added the tags. New to the forum & VBA...It would be great if you could throw some light on the issue. Is it related to the cell protection? The sheet is un-protected.

+ 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. [SOLVED] Insert Row throws error "Insert Method of Range class failed"
    By bg_enigma1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2015, 11:30 AM
  2. "Insert method of Range class failed" in Shared mode
    By BartDeHertogh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2012, 03:50 PM
  3. Excel VBA Runtime error 1004 "Select method of Range class failed"
    By jeskit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2012, 10:16 AM
  4. Error Using filters "Method of range class failed"
    By papermoon in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-12-2010, 10:07 AM
  5. "Select method of range class failed" error
    By RBI in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-22-2008, 10:28 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