Dec 12th, 2007, 11:26 AM
Insert Row in Excel Using VBA
I have read a bunch of posts about inserting a row into excel through VBA, but none helped.
I tried using this code
but it gives me a Run-Time Error '1004', Insert method of Range class failed. The purpose of the code is to insert a row once it finds the right place/row to insert.
Do Until some_condition = true
If some_condition = true then
I saw something about using the following code:
But that gives me the same error too.
Any ideas why my code isn't working? I am using VB 6.3
Last edited by byyu; Dec 12th, 2007 at 12:01 PM.
Dec 12th, 2007, 12:00 PM
Re: Insert Row in Excel Using VBA
My bad... stupid sheet was protected so it didn't work ><
Click Here to Expand Forum to Full Width