Excel Shortcut Indent In Cell
1) A) Excel does not have indentation feature, 2) B) You can specify indentation only if you turn the rulers on, 3) C) Indentation can be set from Format Cells dialog box, 4) D) The indentation can be specified only when printing, 5) NULL. Where indent is the following user-defined function: Function indent(r As Range, n As Long) As Boolean If r.Count = 1 Then indent = (r.IndentLevel = n) Else For Each c In r If c.IndentLevel n Then Exit Function Next indent = True End If End Function To enter the UDF, in Excel, press alt+F11 to open the VBA window.
Indent In Excel 2010
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
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