Determine cell Indent level?

[drvmark]

Want to set a variable equal to the indent level of text in a certain cell.
How can I do this in VBA within Excel?

 

[Jacob Skaria]

intLevel = Range("A1").IndentLevel

If this post helps click Yes

 

[Jacob Skaria]

Use the .Column property as below

Sub Mac()

Dim fld1, fld2 As Range

Set fld1 = Range("A5")
Set fld2 = Range("F5")

MsgBox fld2.Column - fld1.Column

End Sub

 

[Jacob Skaria]

Oops. Sorry. The below is a wrong post///