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 -
----------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------
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
Bookmarks