WorksheetFunction help

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WorksheetFunction not working correctly 1
Excel Macro to automatically go to the right of the last colored cell 0
worksheetfunction 1
Sumproduct Question 7
Is there a macro i can use to copy a cell +1 4
How can I custom autofiller with VBA 1
#VALUE! 10
VBA userform Vlookup Excel 1

Back
Top