remove blank cell from a range
 

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

remove blank cell from a range
 

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

remove blank cell from a range
 

I would like to move the contents of the cells below up into the empty cell.
There could be more than one empty cell in the range. I don't want to delete
the row because that will mess up the contents to the side of the emty cell.
Once all the empty cells have been removed from the range I need to count
how many non empty cells in the range.

"Wigi" wrote:

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