It works for me, what do you get?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"ABEone" wrote in
message ...

Hi all,

I have been trying and trying but I can not get this to work
:

somerange.Formula = "=IF('C03.01 Process
quotations'!$E$6="""";"""";'C03.01 Process quotations'!$E$6)"

So if the source is blank, leave blank otherwise put value in there.
First I had only:

somerange.Formula = "='C03.01 Process quotations'!$E$6"

which works, but leaves zeros when source is has a blank value.

Thanks


--
ABEone
------------------------------------------------------------------------
ABEone's Profile:
http://www.excelforum.com/member.php...o&userid=30715
View this thread: http://www.excelforum.com/showthread...hreadid=503826