Keep getting "Object Variable or With block variable not set" error with macro

[MSFSC]

http://www.excelforum.com/excel-prog...selection.html

I have been working with this spreadsheet for a few days (see above thread).

RYLO has been most helpful (TY!) and I was feeling pretty good until a few minutes ago. I attempted to modify "macro_1a1ay" to look into the "comments" sheet (column a) for a specific text string. If that text string is found, I have it delete the entire row, then re-sort the page and return to the calling page. It works well as long as it finds something. When it does not find the string (i.e. like now when the page is blank) it gives me the run-time error mentioned above.

I know my code is sloppy, I am just learning and probably have too much extra junk in it. Any ideas on how to fix this would be great! Thanks, Rob