Filtering Out Blank Cells that Aren't Really Blank

[phelbin]

I receive a report that comes to me in sections, and the first task is to sort the total list. There are a few blank rows between each section, but for some reason they're not really blank. ISBLANK returns false. So when I try to sort the entire list, it puts these non-blank rows up top.

I'm using the following code to sort. Is there a way to filter out the blank cells that aren't really blank (see attached)?

Please Login or Register  to view this content.

[humdingaling]

Please Login or Register  to view this content.

not sure why its doing that but a work around is just to delete the "Blank" rows which are at the top

[Greg M]

Hi there,

Try the following code and see if it does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[phelbin]

Greg, that's exactly what I was looking for. Thanks so much!!

[phelbin]

The code works in my example workbook, but as soon as I get it into my larger workbook it stops working. I keep getting Run-time error 9: subscript out of range. Any ideas?

[phelbin]

Humdingaling, I just noticed your code, and it fixed my issue. Thanks!!

[Greg M]

Hi again,

The error you mention will occur if you don't change the name of the worksheet to the appropriate value in the following line:

Please Login or Register  to view this content.

Regards,

Greg M