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?

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?

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?

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?