| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using countif function in code
How can I express this in VBA code:
countif(c:c,c2) Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using countif function in code
MsgBox Application.COUNTIF(Columns("C"), Range("C2")) HTH Bob "Bradly" wrote in message ... How can I express this in VBA code: countif(c:c,c2) Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using countif function in code
On Thu, 4 Feb 2010 13:47:01 -0800, Bradly
wrote: How can I express this in VBA code: countif(c:c,c2) Thanks. Try something like this: WorksheetFunction.CountIf(Sheets("Sheet1").Range(" C:C"), Sheets("Sheet1").Range("C2")) Hope this helps / Lars-Åke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's the vba code equivalent for Countif | Excel Discussion (Misc queries) | |||
| Why does this COUNTIF code not work | Excel Programming | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| doing COUNTIF() in code | Excel Programming | |||
Linear Mode
