another way to do it so it doesn't happen is

DestSheet.Range("B9").Value = Sourcesheet.Range("C31").Value
or for a multicell contiguous range
DestSheet.Range("B9:B11").Value = Sourcesheet.Range("C31:C33").Value

This won't put a null string in the cell. This is just an example, but you
should be able to adapt it to your code.

--
Regards,
Tom Ogilvy

"choice" wrote in message
...
i have an equation in my worksheet: =if(a1=0,"",1) (or any equation that
returns "")
then i have code that copies the value, then pastespecial (values) into
column B, so that i have the actual value and not the equation. the
problem i
am having is that when i paste, the value of "", is not blank. it messes
up
vlookup or sum...etc. so i guess i need to delete if = "" or something
like
that

please help

thank you