Counting cells thru VBA

  • Thread starter Thread starter abxy
  • Start date Start date
A

abxy

Ok, i'm trying to have a label on my userform keep a count of how man
cells on all the worksheets in my workbook in the range H1:H275 an
J1:J275 have today's date in them in them. How can I do this?

Thanks in advance :
 
With WorksheetFunction
num = .Countif(Worksheets("Sheet1").Range("H1:H275),Date) + _
.Countif(Worksheets("Sheet1").Range("J1:J275),Date)
Ed With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

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

Referencing all sheets in a workbook in VBA 3
A question about Counting in VBA 2
Using Countif in VBA 1
Excel VBA 0
Counting Bordered Cells 5
VBA userform Vlookup Excel 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top