Is it possible to filter using row height in Excel
 

to filter out rows of a particular or less than height

Is it possible to filter using row height in Excel
 

You cannot filter for row height using Data - Filter - Autofilter if that's
what you mean. With VBA it's possible to find all rows with a given row
height criteria. You said "filter out". Do you mean to hide those rows?
Or maybe delete those rows? Post back with more detail about what you want
to do with those rows. HTH Otto
"xBRITO" wrote in message
...
to filter out rows of a particular or less than height

Is it possible to filter using row height in Excel
 

This UDF will give the row heights in a helper column.

You then filter on those row height numbers.

Function rowht(X)
rowht = X.RowHeight
End Function

Usage is: =rowht(cellref) then copy down


Gord Dibben MS Excel MVP

On Tue, 29 Jul 2008 03:38:01 -0700, xBRITO
wrote:

to filter out rows of a particular or less than height