Filter text in a column by its Indent, to remove certain text

[Guest]

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.

Any ideas.

 

[Norman Jones]

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