Hi 99TZ250,
I want to filter text in a column by its indent. The format is such that
each cell has text in it which is indented from the text above up to
8 indents. The sequence is then repeated. I want to filter out the 5th to
the 8th indents from the range.
Perhaps you could use the Advanced filter on a helper column in which you
use the following User Defined Function:
'=============
Public Function GetIndent(rng As Range) As Long
GetIndent = rng.IndentLevel
End Function
'<<=============
If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
---
Regards,
Norman