请教，使用Excel VBA，如何统计出某一列中BB重复出现的次数？见图。谢谢！

Question

如题所述

Answer 1

Sub 宏1()
Set myRange = Worksheets("Sheet1").Range("A1:A100")
answer = Application.WorksheetFunction.CountIf(myRange, "BB")
MsgBox answer
End Sub本回答被提问者采纳