Need Help  Formating and Align  VBA Code

Posted on 2012-09-10
Last Modified: 2012-09-10
I have a huge worksheet event code. Is issue is its huger and not aligned properly.
Its appearing like this
     Main loop

                         Loop1 end


                          Loop3 End
Main loop end

What I like the vba c ode to aligned neat and clean like below...

Main Loop

       Loop2 End

Main Loop end

Issue is I am not sure which loop / Condition bracket ends where – as it not aligned properly and there are zillion lines of code. Is it possible to use a editor or something that highlights or lets me know or indicates - where one loop / Condition bracket starts and finishes ?
 That way I can realign and organize the code to look better and manageable. Right now it’s a jungle of mess
Question by:Rayne

    Author Comment

    Thank you
    LVL 12

    Accepted Solution

    You'll have to use something like smart indent. You can download it here...

    Author Comment

    Hello Jared_S,
    This is Perfection to the THE Ultimate
    Thank you for the turbo quick response :)

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
    Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now