Should Be Empty Cells


D

Darrell Lankford

I have a worksheet that looks up information using an IF formula and
enters blank in the cell if the text doesn't match:

IF(A2 = "THIS TEXT","THIS TEXT","")

The problem I'm having is after all the text & blanks are determined
and after I paste special values, the cells are not actually blank. I
mean there is nothing in the cells but for some reason excel thinks it
is and my delete rows macro doesn't work because it tells me no empty
cells can be found and even when I sort, it puts the blank cells at
the top. When I click on & off each cell it then makes the cell blank.

Can anyone tell be how to delete these null rows or make the cells so
they are actually blank?
 
Ad

Advertisements

J

JE McGimpsey

If a cell has a formula in it, it's not blank, and the only way to make
it "actually blank" is to delete the formula...

Don't know what method your macro uses, but you could try checking for

rCell.Value = vbNullString

instead of blank.
 
Ad

Advertisements

D

Darrell Lankford

If a cell has a formula in it, it's not blank, and the only way to make
it "actually blank" is to delete the formula...

Don't know what method your macro uses, but you could try checking for

rCell.Value = vbNullString

instead of blank.






- Show quoted text -


I set the code up so it would set up the AutoFilter, show blanks only,
delete blanks, and then show all. I'm sure it's a better way to get
rid of the blank cells, but this works. When I catch up with my
workload, I'll take a look at other options.
Thanks,
Darrell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top