Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 : 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 : 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
If formula problems | Excel Discussion (Misc queries) | |||
More formula problems | Excel Discussion (Misc queries) | |||
formula problems | Excel Discussion (Misc queries) | |||
Problems with a formula | Excel Worksheet Functions |