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?