Formula problems!!

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

VBA is USA centric.

Try changing your semicolons to commas.



ABEone wrote:
>
> 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

--

Dave Peterson

It works for me, what do you get?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"ABEone" <ABEone.221xhb_1137959402.0593@excelforum-nospam.com> wrote in
message news:ABEone.221xhb_1137959402.0593@excelforum-nospam.com...
>
> 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
>

Originally Posted by Dave Peterson

VBA is USA centric.

Try changing your semicolons to commas.



Dave Peterson

Your are my hero today!!! I have had the same issues with Access, but there I do do everything in VBA with comma's. Thanks a lot!