Excel 2007. I have a column of data containing several blank cells. These
blank cells are spread out all through the column. I want to define a named
range that contains only the non-blank cells of this column.

I have seen a previous post of how to do this using an array formula, but
the solution not only looks cumbersome but doesn't quite appear to do what
I'm looking for anyway. This solution was found at
cpearson.com/excel/noblanks.htm

Does anyone know of a cleaner solution than this?