Posted to microsoft.public.excel.programming

Jeff Wright[_2_] Jeff Wright[_2_] is offline

external usenet poster

Posts: 47

VBA WorksheetFunction problem

Greetings!

Can anyone tell me why I get a runtime error (1004) when running the simple
routine below? The data from B1 to B4 is 1, 2, 3, 4. The remainder of the
column is empty.

Sub cmdCountRows_Click()
Dim Leap As Integer
Leap = Application.WorksheetFunction.CountA("B1:B4")
MsgBox Leap
End Sub

Thanks for your help!

Jeff

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
Application.WorksheetFunction.Match problem	Carl Brehm	Excel Worksheet Functions	1	January 9th 05 02:08 PM
Evaluate or WorksheetFunction Problem	SowBelly	Excel Programming	2	August 28th 04 12:10 AM
Problem using "Find" WorksheetFunction in Excel VBA	wadeni	Excel Programming	1	August 12th 04 02:49 PM
Max WorksheetFunction	solo	Excel Programming	4	February 23rd 04 10:17 PM
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions?	Etien[_2_]	Excel Programming	3	January 13th 04 04:07 PM

All times are GMT +1. The time now is 08:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us