| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to filter using row height in Excel
to filter out rows of a particular or less than height
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Row Height | Excel Discussion (Misc queries) | |||
| need to dbl row height without changing height of cell next to it | New Users to Excel | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) | |||
| resize row height and column height | Setting up and Configuration of Excel | |||
Linear Mode
