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.
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.