Intermittent Unspecified Runtime Error

When you get the error and click Debug is a line highlighted?

Not much code to go wrong really. Personally, I'd split the two Do Loops into separate lines and put Debug.Print commands in between each line of code. Add whatever information might be helpful.

Or, possibly, use Debug.Assert: http://www.cpearson.com/excel/DebuggingVBA.aspx

Hi Norie & TMS,

Thanks for your responses!


Norie - The line highlighted is:

Please Login or Register  to view this content.

TMS - Debug.Pring is a new command to me. I've never heard of it before, so I'll ready through the link you provided and try it out.


Thanks both very much! I'll keep trying to figure this out, and if your suggestions give me any more info I'll post it.