Breakpoint without breakpoint?

[Jaymond Flurrie]

What can cause the code to break and display VBE window and painting a row to yellow other than an error or a breakpoint? Something throws my code to there and it doesn't display an error, neither the line is red (ie. has a breakpoint).

 

[RichardMGreen]

What's the line of code?
Do you have any watches set up on your code?

 

[Jaymond Flurrie]

What's the line of code?
Do you have any watches set up on your code?

No watches set. I need to make sure what line it was, but I think it was the first of these:

shtCharts.PageSetup.PrintArea = Range("A1:A282").Address
strPrintPath = "c:\charts.pdf"
shtCharts.ExportAsFixedFormat xlTypePDF, strPrintPath

But for sure it had something to do with the PDF-printing. It acted like there was a breakpoint, but I'm 100% sure I had removed it.

 

[RoryA]

Have you rebooted? The VBE does that occasionally.

 

[RichardMGreen]

When you're in the VBA code, bring up the watch window to make sure, and delete any watches that are there.

If you can post the line of code I'll try and see what's what.

@Rorya - have you any idea why?

 

[RoryA]

Not specifically. It usually follows an user interrupt of code (Ctrl+Break seems to be a common one) and then code will randomly stop on a line that has nothing wrong with it - clicking Continue usually works with no problems. Sometimes you can get round it with a reboot, other times you need to set Application.EnableCancelKey to xlDisabled at the start of the code and reset it afterwards.

 

[Jaymond Flurrie]

Not specifically. It usually follows an user interrupt of code (Ctrl+Break seems to be a common one) and then code will randomly stop on a line that has nothing wrong with it - clicking Continue usually works with no problems. Sometimes you can get round it with a reboot, other times you need to set Application.EnableCancelKey to xlDisabled at the start of the code and reset it afterwards.

Yeah, this sounds very close to what I had, sorry that I forgot to mention that continue works without any problems.

I'm pretty sure this one will solve the problem, I'll reply back again if I'm still having the issue.

Thanks to all of you!