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