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

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.

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

"nikkiamber" wrote:

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.

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.

"Ken Hudson" wrote:

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

"nikkiamber" wrote:

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.

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.

"nikkiamber" wrote:

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.

"Ken Hudson" wrote:

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

"nikkiamber" wrote:

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.