I have a workbook of invoices column A has name of company and column D has
amount. When applying a filter to column A which contains the name then the
rows 22 thru 360 appear as they contain the data however when the filter is
taken off the rows 353 thru 360 disappear. What could cause this to happen???

Hi acss

Then there is a empty row in your data
Excel guess what the range is and it will stop if it see a empty row or column

Turn off Autofilter
Select the whole range
Turn on auto filter
Try again


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"acss" wrote in message ...
I have a workbook of invoices column A has name of company and column D has
amount. When applying a filter to column A which contains the name then the
rows 22 thru 360 appear as they contain the data however when the filter is
taken off the rows 353 thru 360 disappear. What could cause this to happen???