| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
WorksheetFunction help
I need help using worksheet function.Countif. The following is the code I was
tying to use but I am getting a syntax error and I don't know what the problem is. Any ideas? Worksheets("Today -").Range("A24") = WorksheetFunction.CountIf(E2:E21, "Completed") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
WorksheetFunction help
Hi Ayo
Use WorksheetFunction.CountIf(Range("E2:E21"), "Completed") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ayo" wrote in message ... I need help using worksheet function.Countif. The following is the code I was tying to use but I am getting a syntax error and I don't know what the problem is. Any ideas? Worksheets("Today -").Range("A24") = WorksheetFunction.CountIf(E2:E21, "Completed") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
WorksheetFunction help
I get a "Type Mismatch" error when I did that.
"Ron de Bruin" wrote: Hi Ayo Use WorksheetFunction.CountIf(Range("E2:E21"), "Completed") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ayo" wrote in message ... I need help using worksheet function.Countif. The following is the code I was tying to use but I am getting a syntax error and I don't know what the problem is. Any ideas? Worksheets("Today -").Range("A24") = WorksheetFunction.CountIf(E2:E21, "Completed") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with Application.WorksheetFunction | Excel Discussion (Misc queries) | |||
| 'null reference' when trying to use WorksheetFunction from C# | Excel Worksheet Functions | |||
| Can't use WorksheetFunction | Excel Discussion (Misc queries) | |||
| WorksheetFunction Documentation | Excel Worksheet Functions | |||
| WorksheetFunction with VBA | Excel Discussion (Misc queries) | |||
Linear Mode
