Add More Rows Limited to 2

[fredfarmer]

Hi,

For some reason my macro is only allowing 2 rows added in columns O:R for Parts.

Before if you clicked the shape 'Add More Rows' each time would add another row with no limits.

Can someone please figure out why and possible edit the code?

Thanks,
FF

Please Login or Register  to view this content.

[fredfarmer]

I found it! The date formula was missing in R3.

Thanks

[Roel Jongman]

That is because your macro is overcomplicated. All you want to do is add a row to your table.. so make sure that is all that you do.


below code does what you need..

Please Login or Register  to view this content.

Edit: yes the date missing was the biggest part of the problem. but still 90% of your code is unneeded..

[fredfarmer]

Thank you that seems to work much better!

If you have the time I would greatly appreciate it if you can check my other codes.

[fredfarmer]

I actually do not need the Date column at all can I delete it without affecting the codes?

I think this one is the only one affected:

Please Login or Register  to view this content.