Formatting your VBA code

[shadow12345]

Im awful at keeping my code tidy, and the indents and tabs go all over the place where i copy and paste bit around.

I have two quesitons...
Is there a free VBA code Formater anyone knows of?

Is there a standard convention on how to arrange the code in the first place?

 

[klarowe]

And the fact it will do an entire project in one click... (I'll stop rubbing it in now)

FYI... even though you have probably helped me on one of my many questions and I am grateful for that; at this point in time, I hate you.

I think I'm going insane. I keep trying it hoping it will work, but I keep getting the same result... lol

"The definition of insanity is repeating the same action over and over and expecting different results."

 

[HalfAce]

"The definition of insanity is repeating the same action over and over and expecting different results."

I do this every morning when I go to work!