ExcelBanter - WorksheetFunction help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - WorksheetFunction help (https://www.excelbanter.com/excel-discussion-misc-queries/195587-worksheetfunction-help.html)

Ayo

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")

Ron de Bruin

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")

Ayo

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")

All times are GMT +1. The time now is 11:24 PM.