can't insert more rows even though not at max rows

N

nikkiamber

i can't insert any more rows without closing excel first. no error, it just
doesn't insert. any suggestions? is there a limit to the number you can
insert at a time? i'm not at max rows yet.
 
K

Ken Hudson

Hi,
One thing to check...
Go to Tools > Protection.
If "Unprotect Sheet..." is an option, select it.
 
N

nikkiamber

Thanks. it's not protected. i'm creating a macro to insert rows based on an
input box. it will only go so far and then it won't insert any more. even
when i go back to excel after the macro it won't insert until i close and
reopen. it's not the same number every time, and it doesn't error. it just
doesn't insert.
 
K

Ken Hudson

Do you thnk that some code in the macro is creating the problem? I'm no VB
expert, but, if you post the code here, perahps I or someone else can
identify your problem.
 
Top