Sorry, I assumed you had your basic code.

What exactly do you mean by delete the cell, shift the next cell (column)
right, or next cell(row) up?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"hot dogs" wrote in message
...
Could you explain how to do this please?

"Bob Phillips" wrote:

Check each cell for a value of "".

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"hot dogs" wrote in message
...
I have a spreadsheet which returns a list of parts depending on
information
entered. Depending on the information entered some rows in the list
will
return blank from their formulas. I would like to write a macro to
delete
these blank cells after the list has been created, however the 'Go To'
command function will not detect the blank cells as blank cells as
they
have
a formula entered into them. How can I select these cells and delete
them
from my list, without having to select them and delete them row by
row?