Formula to find Format (Alignment/Indent Level)

[AndrewBT]

Hi all

I have some structured data which uses indentations to display a hierarchy (in the "Format Cells" dialog under "Alignment" there is a box "Indent" which shows the indent/hierarchy level). I'm trying to pull out this indent level without success and hope someone may have some ideas.

I looked at using Get.Cell (http://www.mrexcel.com/forum/showthread.php?t=20611) but indent level doesn't seem to be an option. I tried using 53 to get contents as displayed including formatting but it doesn't include any leading spaces/tabs.

Can anyone help?

Thanks

Andrew

 

[prasadsalian82]

Create a user defined funtion

Function indenture(r As Range) As Integer
indenture = r.IndentLevel
End Function

A1 is the cell for which you want to check the indent
=indenture(A1) will return a 3

 

[AndrewBT]

This did it. Many thanks & sorry that I forgot to feed back!

Andrew