Do you only want to count the non-empty cells in a range?

Or am I missing the point?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"ranswrt" wrote:

I have been trying to write a procedure to remove blank cells from a range of
cell sand then count the number of cells that have something in them. I
don't want to delete the rows that are blank. I have been trying to shift
the lower rows up to fill the blank cells. How is the best way to do this?
Thanks