ExcelBanter - Determine cell Indent level?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Determine cell Indent level? (https://www.excelbanter.com/excel-programming/427730-determine-cell-indent-level.html)

drvmark

Determine cell Indent level?

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

Determine cell Indent level?

intLevel = Range("A1").IndentLevel

If this post helps click Yes
---------------
Jacob Skaria

"drvmark" wrote:

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

Determine cell Indent level?

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

--
If this post helps click Yes
---------------
Jacob Skaria

"drvmark" wrote:

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

Determine cell Indent level?

Oops. Sorry. The below is a wrong post///
--
If this post helps click Yes
---------------
Jacob Skaria

"Jacob Skaria" wrote:

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

--
If this post helps click Yes
---------------
Jacob Skaria

"drvmark" wrote:

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?

All times are GMT +1. The time now is 10:12 PM.