| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB + array formulas
I have the following VB code
Dim cnt as Integer ActiveSheet.Evaluate ("SUM(IF('Data'!$K$7:$K $259<""Cancelled"")*(Data'!$K$7:$K$259<""Reject" "),1,0)") The above code works fine but when I add the following line cnt=ActiveSheet.Evaluate ("SUM(IF('Data'!$K$7:$K $259<""Cancelled"")*(Data'!$K$7:$K$259<""Reject" "),1,0)") I get a type mismatch error. Thanks in Advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| Array formulas | Excel Worksheet Functions | |||
| Array Formulas | Excel Worksheet Functions | |||
| Array formulas | Excel Worksheet Functions | |||
Threaded Mode
