On Oct 12, 12:23 pm, dan dungan wrote:
Hi,

I'm using Excel 2000 and XP pro. When I select a breakpoint and debug
pressing F8, the code seems to work.

When I get to this line of code the variables show the proper values
and the message box does not fire.

For Each rng In myRng
If rng.Value = "" Then
MsgBox "You have not selected a Part Number to quote.",
vbOKCancel
Exit Sub
End If

When I remove the breakpoint and click on the button, the message box
fires.

I don't know why.

Does anyone have any suggestions?


Well its because I didn't press F8 enough times. So, there is some
logic error. I'll work on this.

No help required at this time.

Thanks,

Dan