Indenting VBA code

Abgar,

I think it is a personal preference.

I prefer two spaces.

A lot of people like 4 spaces.

You can change the setting in the VBA Editor:
click on Tools, Options
on the Editor tab, enter the value you want in the Tab width: box
then click on the OK button.

Hi Abgar,

I like using this tool for indenting.

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

Hi Abgar, heres my logic: (remember the purpose is to make it easier to interprit later on, and debug whilest developing the code)

I indent so as to form grouped bits of code using the idea that many statements have 2 parts. examples include...
For...Next
If...Else...End If
While...Wend
With...End With
Select Case...Case...End Select
Function...End Function
Sub...End Sub

i also include Open...Close which many will argue doesnt belong in this group, but i find it helpful

if you are coding and the 2nd part of a statement set does not line up exactly with its first part then you have probably made an error. indenting is especially useful in nested code, when you loose track of End If etc.