Formula problems!!
 

Hi all,

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

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

Formula problems!!
 

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 :confused:
:

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

Formula problems!!
 

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 :confused:
:

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

Formula problems!!
 

Dave Peterson Wrote:
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!:)


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