Posted to microsoft.public.excel.misc

Ayo

external usenet poster

Posts: 489

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with Application.WorksheetFunction	Ayo	Excel Discussion (Misc queries)	4	May 14th 08 11:13 PM
'null reference' when trying to use WorksheetFunction from C#	RandomEngineer	Excel Worksheet Functions	0	April 25th 06 04:21 AM
Can't use WorksheetFunction	Yossi	Excel Discussion (Misc queries)	5	January 25th 06 10:07 PM
WorksheetFunction Documentation	P-A Caron	Excel Worksheet Functions	1	April 12th 05 03:12 PM
WorksheetFunction with VBA	Ghislain Marcotte	Excel Discussion (Misc queries)	2	February 13th 05 07:08 AM

All times are GMT +1. The time now is 08:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us