Syntax error?

[cooldyood]

ActiveCell.FormulaR1C1 = "=if(Countif($J:$J,E2)=1,E2,"""")"

My macro keeps throwing an error at this line. Is there an error in the syntax here?

[Gary Keramidas]

try this
ActiveCell.Formula = "=if(Countif($J:$J,E2)=1,E2,"""")"

--


Gary


"cooldyood" <cooldyood.2ccsvj_1155262814.8071@excelforum-nospam.com> wrote in
message news:cooldyood.2ccsvj_1155262814.8071@excelforum-nospam.com...
>
> ActiveCell.FormulaR1C1 = "=if(Countif($J:$J,E2)=1,E2,"""")"
>
> My macro keeps throwing an error at this line. Is there an error in the
> syntax here?
>
>
> --
> cooldyood
> ------------------------------------------------------------------------
> cooldyood's Profile:
> http://www.excelforum.com/member.php...o&userid=35611
> View this thread: http://www.excelforum.com/showthread...hreadid=570597
>

[cooldyood]

I tried that but the macro got stuck at that line. XL froze, I had to kill it.

[cooldyood]

Any other suggestions? Is there a syntax error on this line? I've tried the following:

ActiveCell.FormulaR1C1 = "=if(Countif($J:$J,E2)=1,E2,"""")"
ActiveCell.Formula = "=if(Countif($J:$J,E2)=1,E2,"""")"

[Dave Peterson]

The first line won't work--you're using .formulaR1C1 with A1 reference style
(J:J and E2).

If you put this in the activecell manually, does excel continue to work ok:
=if(Countif($J:$J,E2)=1,E2,"")

I don't see anything with the formula or the second sample of code.



cooldyood wrote:
>
> Any other suggestions? Is there a syntax error on this line? I've tried
> the following:
>
> ActiveCell.FormulaR1C1 = "=if(Countif($J:$J,E2)=1,E2,"""")"
> ActiveCell.Formula = "=if(Countif($J:$J,E2)=1,E2,"""")"
>
> --
> cooldyood
> ------------------------------------------------------------------------
> cooldyood's Profile: http://www.excelforum.com/member.php...o&userid=35611
> View this thread: http://www.excelforum.com/showthread...hreadid=570597

--

Dave Peterson

[Simon Lloyd]

Damn Dave your good, thats why i always look forward to your responses!

Regards,
simon

[Dave Peterson]

But who knows why it's locking up????

Simon Lloyd wrote:
>
> Damn Dave your good, thats why i always look forward to your responses!
>
> Regards,
> simon
>
> --
> Simon Lloyd
> ------------------------------------------------------------------------
> Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
> View this thread: http://www.excelforum.com/showthread...hreadid=570597

--

Dave Peterson

[cooldyood]

Yes, it works if I manually put that formula in.

[Dave Peterson]

I still don't have another guess.

Sorry.

cooldyood wrote:
>
> Yes, it works if I manually put that formula in.
>
> --
> cooldyood
> ------------------------------------------------------------------------
> cooldyood's Profile: http://www.excelforum.com/member.php...o&userid=35611
> View this thread: http://www.excelforum.com/showthread...hreadid=570597

--

Dave Peterson