Thread: Formula problems!!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ABEone ABEone is offline
external usenet poster
  
Posts: 1
Default 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


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

Reply With QuoteReply With Quote