There is a difference between blank cells, and those that contain an empty
string. I suspect your blank cells are the latter.

Autofilter *might* pick up these empty strings as blanks (then you could
select them all & hit delete) - give it a try?


--
HTH
Roger
Shaftesbury (UK)





"Starguy" wrote in message
...
I have a column with formulas. some formulas return blank cells and some
return data.
I copy this column and Paste Special it as Values then I select these
values
and press F5 and select Blanks from Special tab options (infact I want to
remove blank cells) but it returns a msg that "No cells were found"
despite
having blanks in the range. what's wrong with this.

however when I press delete on any blank cell and then use Go To command
to
select blanks it then selects only that cells upon which I pressed Delete.

please explain why Excel do not recognise Pasted as values cells as
blanks.