improving functionality of lengthy macro

Good day,

I am looking for some simple advice,

I did my undergrad in computer science however we always worked with simple programs (about 100 - 200 lines of code tops)

For work I am making an excel macro that seems to get larger every day and I am starting to get lost in my won code ...

or at least it takes me a while to find the place I'm looking for ....

what is the best way to organize my code?

I try using comments for every few batches of code, however I am getting close to 1000 lines of code,

I would think dividing my code into sub functions and calling them would be better,

any other suggestions?

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread titles and adjust accordingly...
• Please PM me when complete and this post will be removed which will reset the replies to zero…

I think you are on the right track. Dividing your macro up into smaller Sub's that you call could help in the trouble shooting of the code.

Sub MacroStartsHere()
    CalledOne
    CalledTwo
    CalledThree
End Sub

Sub CalledOne()
    MsgBox "First Sub is Done"
End Sub

Sub CalledTwo()
    MsgBox "Second Sub is Done"
End Sub

Sub CalledThree()
    MsgBox "Third Sub is Done"
End Sub

Now when the first Sub runs, in order, the subsequent Sub's will be called.

If the Sub's get out of control, in other words, many of them, you can highlight (for instance) CalledOne in the first Sub and then select Shift + F2 which will take you to that sub.

You're welcome…glad you have a workable solution and thanks for the feedback...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.