countif in VB

  • Thread starter Thread starter mohavv
  • Start date Start date
M

mohavv

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif, multiple value range PLEASE HELP 2
Combining Percent with Text 5
COUNTIF on result of formula 4
Range values in a function 2
Please help with countif formula 4
Excel Need Countifs Formula Help 0
Excel IF function in excel 2
Excel Copy COUNTIF while retaining reference 7

Back
Top