Posted to microsoft.public.excel.programming

Ayo

external usenet poster

Posts: 489

WorksheetFunction Calculation Error

errorWS.Range("B3").Value = Application.WorksheetFunction.CountA("A5:A" &
errorWS_startRow - 1)

The above line of code is always 1, even when errorWS_startRow is much 1,
i.e:
errorWS_startRow=144, 749 etc.

Any ideas what is going on?

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
worksheetfunction.sum error	Monique	Excel Programming	4	July 17th 05 04:43 PM
Error '1004' in WorksheetFunction	oakman[_16_]	Excel Programming	0	November 18th 04 01:48 PM
Error '1004' in WorksheetFunction	oakman[_15_]	Excel Programming	1	November 17th 04 08:16 PM
Error '1004' in WorksheetFunction	oakman[_14_]	Excel Programming	1	November 17th 04 03:56 PM

All times are GMT +1. The time now is 02:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us