auto filter

[Harvey Waxman]

It appears that autofilter doesn't work if there are blank rows. The sort goes
only up to the first blank row, true?

Any work around?

OS 10.3.2

 

[J.E. McGimpsey]

It appears that autofilter doesn't work if there are blank rows. The sort
goes
only up to the first blank row, true?

Any work around?

If you don't have a multi-cell range selected, Autofilter will
filter the "Current Region" which is the area around the active
cell, bounded by the first blank row and blank column in each
direction (or the edges of the sheet).

To filter a range that includes blank rows, select the entire area
you wish to filter (or, if using a macro, qualify the Autofilter
property with the entire range: Range("A1:A1000").AutoFilter(...))

 

[Harvey Waxman]

If you don't have a multi-cell range selected, Autofilter will
filter the "Current Region" which is the area around the active
cell, bounded by the first blank row and blank column in each
direction (or the edges of the sheet).

To filter a range that includes blank rows, select the entire area
you wish to filter (or, if using a macro, qualify the Autofilter
property with the entire range: Range("A1:A1000").AutoFilter(...))

Thanks