select the range, do
Edit=Replace
Replace What: Leave Blank
Replace With: $$$$

then reverse

Edit=Replace
Replace What: $$$$
Replace With: leave blank

clearly you can do this with code as well.

--
Regards,
Tom Ogilvy


"markx" wrote in message
...
Hi people,

I made a copy/paste special values from one sheet (formulas) to another.
These formulas give me either a numeric value or blank ("") cell.
However, the blanks that I copied/pasted are in fact "false blanks": if I
use xlDirection, it goes to the very end of the pasted range, even if in
between the cells are equal to "".
Also, if I check the "false blank" cells with the =ISBLANK(), it gives me
"FALSE".

Do you know how to convert these "false blanks" to the normal blanks? (I
know I can do it manually by going through the range and pressing "delete"
key where needed, but I would rather look for a VBA solution, if it
exists...)

Your help would be much appreciated,
Thanks,

Mark