Excel VBA formula call in VBA
 

Hi,
Can someone tell me how to call an excel VBA formula from VBA. I
tried the following:
Activecell.value = "{=SUM(IF(COUNTIF(D4:E15,D4:E15) =0, "",
1/COUNTIF(D4:E15,D4:E15)))}" but that isn't working.
I got the code from the j-walk website. It is suppossed to return a
count of all the unique values in a range and it works fine when
entered into a cell directly.
TIA

Excel VBA formula call in VBA
 

Hi Dave,

Try this,

Activecell = [SUM(IF(COUNTIF(D4:E15,D4:E15)=0,"",1/COUNTIF(D4:E15,D4:E15)))]


Salutations!


"DaveEngle" a écrit dans le message de om...
Hi,
Can someone tell me how to call an excel VBA formula from VBA. I
tried the following:
Activecell.value = "{=SUM(IF(COUNTIF(D4:E15,D4:E15) =0, "",
1/COUNTIF(D4:E15,D4:E15)))}" but that isn't working.
I got the code from the j-walk website. It is suppossed to return a
count of all the unique values in a range and it works fine when
entered into a cell directly.
TIA