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