Utility to "clean up" VBA code?

[chuckles1066]

Sorry if this is a stupid question!

I have inherited some spreadsheets with macros but the person who wrote them has left-justified everything.

There are no indentations etc and it's making trying to follow the code really awkward.

Is there something I could use that would indent the bits that would normally be indented?

TIA.

 

[Michael M]

Everybody treats their code differently to some extent, so I'd imagine it would be nigh impossible to get a utility that would be able to decide which way you wanted it.
However, you can Indent in blocks by highlighting a number of lines and pressing the Tab key.
Having said all that I'm sure someone will prove me wrong with the utility.

 

[VoG]

Maybe http://www.oaltd.co.uk/Indenter/Default.htm

 

[Michael M]

Hi Peter
Well I'll be darned !!
I never cease to be amazed at what is available !!!!!

 

[diddi]

greetings M

i will scratch around for some utilities for you to try out. i have a suite of them somewhere in the digital equivalent of the tea-chest in the garden shed

 

[Michael M]

Hi P
Okay....always willing to try and improve the VBA.

 

[chuckles1066]

Thanks all, especially VoG for the link.

I was working on the premise that there was a "standard and accepted" way of coding macros so that they were easily understood, a "best practice" if you like.

 

[Michael M]

There kinda is !!
You've seen most posters Indenting and commenting and declaring....but person "A"'s "best practice" is sometimes different to person "B"'s