Is it possible to filter using row height in Excel

O

Otto Moehrbach

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
 
G

Gord Dibben

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
 
Top