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