How many lines of code can VBA run?

[excelnoob001]

When I run my code in debug mode, line by line, it works.

However, when I run it as a macro through a button, the macro stops abruptly
about 1/5 through the entire code.

Any ideas why this is happening?

Thank you.

 

[William_G]

For sure this is not because of a limit to the number of lines that can be run.

You need to find out why the conditions in your program are different when you step through it from how they are when you let it run unhindered by debug mode.

Try to put things in your code which tell you what's going on inside it.

I've been using "MsgBox" a lot just lately but like you I'm an Excel noob so there must be better ways. At least I hope there are.

Try to avoid the trap that you have already fallen into. They call it "the XY problem" and I'll leave you to search for that.

Don't feel bad; we've all been there sometime.

 

[Fluff]

It would help if you posted your code, pointed out which line it fails on and what the error number & message is

 

[sykes]

By any chance, is there a brown (or perhaps a different colour) round "blob" to the left of your code - in the margin - with the associated line of code highlighted the same colour? If so, this is a "Break" where code will stop running in automatic mode, but running line-by-line will overcome this, and carry on executing.
The break mode is used in fault finding...