| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula alternate column call value | Excel Worksheet Functions | |||
| formula alternate column call value | Excel Worksheet Functions | |||
| Formula to Sum cells below a target call | Excel Worksheet Functions | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
| Call list length in formula | Excel Discussion (Misc queries) | |||
Linear Mode
