H
Hydra
Set Myrange = Worksheets("Sheet1").Range("a1, a" & nrows)
NumberOfSummaries = Application.WorksheetFunction.CountIf(Myrange,
"SUMMARY:")
this throws and error that says "Unable to get countif function of the
worksheet function class"
Any idea what I'm doing wrong?
NumberOfSummaries = Application.WorksheetFunction.CountIf(Myrange,
"SUMMARY:")
this throws and error that says "Unable to get countif function of the
worksheet function class"
Any idea what I'm doing wrong?