Solved: Insert A Row

[sooty8]

Hi All

Had help a couple of weeks ago from Md regards a Userform however hit a snag when inserting a row when the last row is filled - the problem is better explained by the attached. As I'm not using the usual method for finding the next row.

Any help much appreciated

Regards

Sooty8

[Bob Phillips]

Running that book I cannot see what the problem is. Why don't you tell us what is wrong.

[sooty8]

Hi Xld

Must be a problem on my sheet then - If I enter another horse to fill Row6 - I have then run out of rows when entering another horse it fills Row8 whereas if row6 is filled and a row is inserted manually below row6 the new info is inserted in row 7. and the calcs in row8 auto drop in place.
Does the above explain all?

Regards

Sooty8

[nilem]

Try this. See attachment.

[sooty8]

Hi Nilem

Thanks for the reply have had a look and run your attachment however it does not insert a row below Row6 it just inserts the data off the UserForm into row 6 - have tried a few times and it always overwrites the data. What I wanted was when row6 is filled it would then insert a new row and when the next data is entered on the sheet it would enter it on row7 and so on when ever the data is entered off the UserForm this would automatically happen.
Any further suggestions much appreciated.

Regards Sooty8

[nilem]

:oops: Cells(freerownum, 1) instead of Cells(i - 1).

It should now be correct.:yes

[sooty8]

Hi Nilem

Thanks for the help - just what I needed
again many thanks

Sooty8