Re: Syntax Problem with formula code
From: Todd Huttenstine (anonymous_at_discussions.microsoft.com)
Date: 05/10/04
- Next message: Keith: "Running a Macro"
- Previous message: David McRitchie: "Stop Cell Edit when DoubleClick"
- In reply to: Bernie Deitrick: "Re: Syntax Problem with formula code"
- Next in thread: JE McGimpsey: "Re: Syntax Problem with formula code"
- Reply: JE McGimpsey: "Re: Syntax Problem with formula code"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 10 May 2004 09:11:30 -0700
Ah that did the trick. Thank you both for your help.
Now what determines when I use the R1C1 option? I have
always used it thinking that was just how it was.
Todd
>-----Original Message-----
>Todd,
>
>Change
>
>ActiveCell.FormulaR1C1
>
>to
>
>ActiveCell.Formula
>
>B6 is not an RC type address.
>
>HTH,
>Bernie
>MS Excel MVP
>
>"Todd Htutenstine" <anonymous@discussions.microsoft.com>
wrote in message
>news:addb01c436a7$37fecba0$a501280a@phx.gbl...
>> I doubled quoted everything and now its putting single
>> quotes around my cell addresses and that is causing my
>> formula to come up with the NAME error.
>>
>> I put this in the VBA code and VBA likes this:
>> ActiveCell.FormulaR1C1 = "=IF(AND(B6<>"""",E6<>"""")
>> =TRUE,IF(B6="""",,) & IF(B6<>"""",B6&"" - 1YR"",) & IF
>> (E6="""",,) & IF(E6<>"""",""; ""&E6&"" - 2YR"",),IF
>> (B6="""",,) & IF(B6<>"""",B6&"" - 1YR"",) & IF
(E6="""",,)
>> & IF(E6<>"""",E6&"" - 2YR"",))"
>>
>> However when I run the code it puts the following in the
>> cell:
>> =IF(AND('B6'<>"",'E6'<>"")=TRUE,IF('B6'="",,) & IF
>> ('B6'<>"",'B6'&" - 1YR",) & IF('E6'="",,) & IF
>> ('E6'<>"","; "&'E6'&" - 2YR",),IF('B6'="",,) & IF
>> ('B6'<>"",'B6'&" - 1YR",) & IF('E6'="",,) & IF
>> ('E6'<>"",'E6'&" - 2YR",))
>>
>> I need for it to put this formula in the cell instead:
>> =IF(AND(B6<>"",E6<>"")=TRUE,IF(B6="",,) & IF
(B6<>"",B6&" -
>> 1YR",) & IF(E6="",,) & IF(E6<>"","; "&E6&" - 2YR",),IF
>> (B6="",,) & IF(B6<>"",B6&" - 1YR",) & IF(E6="",,) & IF
>> (E6<>"",E6&" - 2YR",))
>>
>>
>> >-----Original Message-----
>> >Double the double quotes, e.g.:
>> >
>> > ...AND(B6<>"""",E6<>"""")=TRUE,...
>> >
>> >
>> >In article <aa9101c436a3$31849c40$a401280a@phx.gbl>,
>> > "Todd Huttenstine"
<anonymous@discussions.microsoft.com>
>> wrote:
>> >
>> >> Hey guys below is a line of code in my project. In
the
>> >> VBE it is showing up in red because it does not like
>> >> the "" within the formula. I know the format to
enter
>> the
>> >> formula in the cell is correct because I have used
the
>> >> same format on other occasions. Its just so many of
>> >> the "" is messing it up. How do I correct this?
>> >>
>> >> ActiveCell.FormulaR1C1 = "=IF(AND(B6<>"",E6<>"")
=TRUE,IF
>> >> (B6="",,) & IF(B6<>"",B6&" - 1YR",) & IF(E6="",,) &
IF
>> >> (E6<>"","; "&E6&" - 2YR",),IF(B6="",,) & IF
>> (B6<>"",B6&" -
>> >> 1YR",) & IF(E6="",,) & IF(E6<>"",E6&" - 2YR",))"
>> >.
>> >
>
>
>.
>
- Next message: Keith: "Running a Macro"
- Previous message: David McRitchie: "Stop Cell Edit when DoubleClick"
- In reply to: Bernie Deitrick: "Re: Syntax Problem with formula code"
- Next in thread: JE McGimpsey: "Re: Syntax Problem with formula code"
- Reply: JE McGimpsey: "Re: Syntax Problem with formula code"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
