selecting cells which contain formulas but return blanks

H

hot dogs

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?
 
B

Bob Phillips

Check each cell for a value of "".

--
HTH

Bob Phillips

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

hot dogs

Could you explain how to do this please?

Bob Phillips said:
Check each cell for a value of "".

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
B

Bob Phillips

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)
 
Top