Blank cell not really blank

  • Thread starter Thread starter jrb
  • Start date Start date
J

jrb

In working to eliminate blank cells in a range, it has become apparen
that when I do a range/copy/paste special/values although the copyie
cells appear blank they reall are not. Is there a better way to copy
range of values that will truly leave the blank cells blank. I need t
do a count via counta() and of course that will not work because it i
seeing something.

Thanks, I really appreciate this site.

JR
 
Thank you for that question that turned a light bulb on in my head. Th
copy is coming from another part of the sheet that contains i
statements.

ie. =IF($F9<=I$5, IF($F9>=I$6,I$7,""),"") . I see that maybe using th
null may be causing the problem. The purpose was to keep the cel
blank if it was not true. Is there a better way to do this
 
All depends :-) A cell with a formula in it that returns a blank, is not a
blank cell, and if you try =ISBLANK() on it, it will return FALSE.

If you want your data to stay as is at source, but don't want the blanks when
you copy and paste, then you could use the routine I gave you in the other
thread. Note though, this will delete ALL such blank on the sheet, so if you
wanted it modified for just a selection then just shout.
 
Back
Top