Macro skips lines of script

[rjunk]

I have a macro that has a loop in it. Because I don't know what else I can use to end the loop, it is written to "End Sub" if certain criteria is met.
After the text for the loop ends, I still have a few lines of code.
Once the criteria for ending the loop is met though, the macro stops and the last few lines of script are ignored.
Any suggestions?
Below is the loop, as well as the lines that are being skipped:

Do Until ActiveCell.Row = 65536
Selection.End(xlDown).Select
Selection.ClearContents
If ActiveCell.Row = 65536 Then Exit Sub
ActiveCell.Offset(1, 0).Select
ActiveCell.EntireRow.Insert
Range("Q1").Select
Loop
Selection.AutoFilter Field:=17
Range("A1").Select
End Sub

 

[Chitosunday]

Instead of exit sub use "exit do"

 

[TommyGun]

Sure. Instead of using Exit Sub inside your loop, use Exit Do instead. This will exit your loop but still allow your code to finish.

 

[rjunk]

You guys are great.
Any suggestions as to where/how to learn this stuff?

 

[Chitosunday]

The help function in our excel application can tell you that. However, if you want to expand your knowledge more, just
visit this site more often and you will learn many things everyday.