Selecting each cell in a column that isn't empty

Hello,

I've got a few rows at the top of my sheet with specific formatting I need
I've got a macro with a For loop that is going through each cell in one column and then deciding based on its contents which formatting to copy from the top and then paste in that cell's row.
This is what I did for all of the empty cells. Is there a way to tell the macro to get the cells that aren't empty? Can I select all of the cells that this code below does not select? Thank you in advance.

Please Login or Register  to view this content.

Wow thanks! That worked perfectly!