Posted to microsoft.public.excel.programming

Bishop

external usenet poster

Posts: 208

Runtime Error 9

I have the following code:

Dim G as Integer

G = Worksheets("Movies").WorksheetFunction.CountIf("AE :AE", "G")

I'm assuming I'm simply not using the CountIf function correctly but I keep
getting Subscript Out Of Range. What am I doing wrong?

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
runtime error '1004' application or object defined error	Janis	Excel Programming	4	November 18th 09 03:01 PM
runtime error 13 - type mismatch error in Excel 97 on Citrix	Kevin Maher	Excel Programming	7	March 8th 08 11:48 AM
runtime error '1004' application or object defined error. Please help	deej	Excel Programming	0	August 1st 07 09:26 AM
Excel 2003 Macro Error - Runtime error 1004	Cow	Excel Discussion (Misc queries)	2	June 7th 05 01:40 PM
Syntax Error Runtime Error '424' Object Required	sjenks183	Excel Programming	1	January 23rd 04 09:25 AM

All times are GMT +1. The time now is 07:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us