Using SpecialCells to set a range of cells that are BOTH visible and non-blank?

I was hoping to be able to do something like the following to select visible and non-blank cells, but not sure if it's possible or what the right syntax is. I'm aware I could just set the visible cells and then check if each has a value (or vice versa), but was hoping this would work. Neither of these do.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Both of these worked for me.

Please Login or Register  to view this content.

See if this VBA code adds any clarity to your issue:

Please Login or Register  to view this content.

Does that help?

Thanks everyone, you're all correct. That syntax does work.

Turns out there is a difference between cell values of "" and cell values of Empty. SpecialCells(2) will include cell values of "", which I don't want.

So I just included code to change "" to Empty, and now it works as expected. Here's the code for anyone interested.

Please Login or Register  to view this content.