Hanging indent - VBA solution Excel?

[MikeL]

Hi ,
I have Wrap Text enabled thru VBA. How do I indent the second line by two spaces in VBA? I set to True but doesn't seem to work.

With Selection
.VerticalAlignment = xlBottom
.WrapText = True
.Orientation = 0
.AddIndent = True
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With

 

[Misca]

There are at least two ways to do it:

.IndentLevel = 2

or

.InsertIndent 2

I don't know what is the difference because to me they both seem to do exactly the same thing.

 

[MikeL]

Thanks for the response.

Here is my problem. I want to do what is called a hanging indent. Meaning that the indention only starts at the second and subsequent lines after the wrap text. It appears that .IndentLevel and InsertIndent are applying to all lines in the cell. See attached results after using the suggested code. How can indent only be applied to second and subsequent lines?

 

[Fluff]

As far as I know it cant, the indent applies to the entire cell.

 

[MikeL]

As far as I know it cant, the indent applies to the entire cell.

Thanks, seems as if it has been a limitation of Excel VBA for some time. I saw posts asking to do this from 15 years ago.

 

[Fluff]

I wouldn't call it a limitation, Excel is not a word processing or DTP app.