Counting cells thru VBA

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 :
 
B

Bob Phillips

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)
 
Top