software

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.

Hi 99TZ250,

gt;I want to filter text in a column by its indent. The format is such that
gt; each cell has text in it which is indented from the text above up to
gt; 8 indents. The sequence is then repeated. I want to filter out the 5th to
gt; 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:

'=============gt;gt;
Public Function GetIndent(rng As Range) As Long
GetIndent = rng.IndentLevel
End Function
'lt;lt;=============

If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

www.mvps.org/dmcritchie/excel/getstarted.htm---
Regards,
Norman