Richard, I have a spreadsheet that needs to be filtered, then sorted. I am filtering out the non-blank cells, then trying to sort, ascending. Most of the list I'm sorting disappears. I read that the autofilter I've used corrupts the macro. Is there another way to sort non-blanks other than autofilter?

Thanks, Kathy Boyette