Excel Indent function flexibility

[Joon Kim]

Dear experts,

Excel cell function (or feature) called "indent" is set with number of
indents.

When I set it up with 1 indent, I see space (size of 3 spaces) before the
text.

Can I reset the size of it using VBA?
For example, give smaller sized indent (2 space sized indent) before the
text for each cell.
Is that possible?

Please help.
Thanks in advance.

Joon @ MSRT

 

[Bob Phillips]

For Each cell In Activesheet.UsedRange
cell.IndentLevel = 2
Next cell


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)