Determine cell Indent level?

D

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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inconsistent formatting of section numbers 0
Parapgraph Indentation 0
Any way to know the PRECISE indent values? 3
Range headings 0
Footer On Last Page Only Not Working 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Macro to select and delete levels of a document 2
Problem with MS Word paragraph and character styles: format getting messed up 2

Top