Macro that fills in cells needs to skip 2 rows

I have a workbook that uses a macro to add a sheet then fill in the cells on a summary sheet to link the info from the new sheet to the summary sheet. The problem that I am having is what code to use once the first page of the summary sheet is full, and then need to start filling out the second page on the summary sheet, since the first 2 rows on the second page are the headings, I need the macro to skip over these rows.

Here is the macro to fill in the cells.

Please Login or Register  to view this content.

After the macro runs 35 times or the value of "ShtName" is 40 is when the macro needs to skip the 2 rows which are rows 48 and 49 of the summary sheet.

Also I will need to put a limit on how many times the macro will run which is 80 times or the value of "ShtName" is 85.

Any help is greatly appreciated.
Thanks
Weston

I figued out how to stop the macro by using

Please Login or Register  to view this content.

but still need help with skipping the 2 rows

This is what I have come up with so far, but I cant get the If...Then...Else statement to work at the bottom

Please Login or Register  to view this content.

Can anyone see what Im doing wrong