How to use count in range of cells

  • Thread starter Thread starter nieuws
  • Start date Start date
N

nieuws

=count(B2:J10)

works in a macro, but how to use this function in VBA?
Hans
 
One way:

Dim nResult As Long
nResult = Application.Count(Range("B2:J10"))
 
You must log in or register to reply here.

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

Excel VBA - counting cells by colors and names to it in two different rows. 0
using 2 different IF statements 2
Is there a way to count colored cells that are conditionally formatted? 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Count of Font Format 1
Fuction to return and evaluate fuction 1
using excel formulas in VB coding 4
Count in a range of numbers 8

Back
Top