 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008countif in VB
Hi, Can this be done shorter, without using cell B1 Range("B1").Formula = "=COUNTIF(A:A,""*Stock*"")" Stock = Range("B1").Value Range("B1").Clear Cheers, Harold Dim Stock As Long Stock = Application.CountIf(ActiveSheet.Range("a:a"), "*stock*") MsgBox Stock > Hi, > [quoted text clipped - 7 lines] > > Harold  SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.