Posted to microsoft.public.excel.programming

Michael168[_45_] Michael168[_45_] is offline

external usenet poster

Posts: 1

Please Correct the mistake

I have this formula in a macro.

If sh2Row = 30 Then
sh2.Cells(32, 3).Value = _
Application.WorksheetFunction.CountIf(Range("C1:C3 0"), 0)
End If

It gives me error. Please Help

Thanks & Regards.

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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
where is the mistake?	xavi garriga	Excel Discussion (Misc queries)	8	September 24th 07 12:06 PM
mistake in formula	pm	Excel Discussion (Misc queries)	4	January 30th 06 05:31 PM
I saved it by mistake!!!!	Ellie Ellis	Excel Worksheet Functions	2	November 27th 05 09:40 PM
Found Mistake can't correct.	dvonj	Excel Worksheet Functions	7	March 21st 05 08:11 PM
If I get the help box up by hitting F1 by mistake, how can I get .	Last1Standin	Excel Discussion (Misc queries)	1	February 17th 05 08:56 PM

All times are GMT +1. The time now is 10:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us