View Single Post
 
Old 04-13-2020, 06:31 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

What Arvi said, beno—but also, let us know what error you got. And when you get the error message you are probably presented with a choice of End or Debug buttons; if you choose Debug, you'll see the statement highlighted that is the cause of the error. (Well, usually it's the cause. Sometimes it's just where VBA was when it noticed the error.) That would help us help you figure it out, too, if it isn't obvious to you by this time.

If you have trouble figuring out what Arvi was trying to tell you about "clicking on the left border", you can accomplish the same thing by writing the command "Stop" anywhere in the program.

Once you know what's causing the problem, and have it fixed, we can come back to that "subroutine wrapping" thing you were talking about; I'm not sure what you mean, but I'm all about making subroutines where you have the slightest excuse for it.
Reply With Quote