Hello,
I'm looking for a VBA script to find the total number of cells in a worksheet with the text "VOIP", but not "VOIP*", and output the count cell "S5"
Any assistance is greatly appreciated.
The following is giving me all instances of VOIP, including VOIP*
I'm looking for a VBA script to find the total number of cells in a worksheet with the text "VOIP", but not "VOIP*", and output the count cell "S5"
Any assistance is greatly appreciated.
The following is giving me all instances of VOIP, including VOIP*
Code:
Range("S5").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(R1C1:R3057C13,""VOIP"")"