Runtime error for Range("BV")=IF(COUNTIF($AO2:$AV2,BH$1)=1,BH$1,"") & Range("BV").formula=IF(COUNTIF($AO2:$AV2,BH$1)=1,BH$1,"")

[hemant86]

HI,

I'm getting runtime error for Range("BV")="=IF(COUNTIF($AO2:$AV2,BH$1)=1,BH$1,"")" & Range("BV").formula="=IF(COUNTIF($AO2:$AV2,BH$1)=1,BH$1,"")"
The format works fine when I try to enter other formulas like Vlookup etc.

Need to know how to assign "=IF(COUNTIF($AO2:$AV2,BH$1)=1,BH$1,"") " to a cell through VBA

Any help is highly appreciated.

 

[Norie]

You need to double up the quotes in the formula and use a valid range.

Range("BV2:BV10")="=IF(COUNTIF($AO2:$AV2,BH$1)=1,BH$1,"""")"