Then the cells are not blank.
Perhaps they look blank due to a formula that returns "" if no data?
Or you have a space or spaces in the cells that look blank?
Are there formulas?
If not, in a helper column enter =LEN(C1)
Copy down.
What results do you get for the "surely blank" cells.
Gord
On Fri, 7 Dec 2007 11:15:02 -0800, Outlook, eh?
wrote:
Eventhough I surely have blanks, it is saying "No Cells Found"...
"Gord Dibben" wrote:
Select column C and F5SpecialBlanksOK
EditDeleteEntire Row
Gord Dibben MS Excel MVP
On Fri, 7 Dec 2007 08:27:07 -0800, Outlook, eh?
wrote:
I was wondering what function I should use if one of the columns has a blank
in it.
In this case I want to get rid of the Ringo row (Go Figure).
A B C
Paul Yes
Ringo
John Yes
George Yes
Thanks as always. You have saved my neck many times!