Escape My Debugger!

Okay, So I'm trying to get rid of using the debugger as a part of my process. This macro will create a new Worksheet and cut/paste the lines that contain the criteria data. If none of the lines contain the criteria, then it's supposed to skip making that particular new Worksheet. The problem is that when it does not find any of the criteria data, the debugger sends me to the "If Not rng2 Is Nothing Then rng2.EntireRow.Delete" line. I'm thinking all I need to do is tell it to skip that line if there's no data matching the criteria. I just don't know how to tell it that.

I tried End If, On Error GoTo 0,& On Error GoTo Next after that line to no avail. As of now, I just turn that line into a note line when the debugger directs me to it. Then I re-run the macro.

BTW, this is just a sample of the macro... it's actually got about 50 iterations.

Please Login or Register  to view this content.

Hi

When it debugs, use the immeditate window and find out exactly what is in rng2. If that doesn't help, then build a working example with the other bits of code that are relevant (you must have some global variables or they are set in part of the code you haven't supplied) and attach it to the post for review.


rylo