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

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


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Joon Kim" wrote in message
...
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