View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default 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")