Count Merged Cells In Excel - Solution!

[@ShrutiAggarwal555]

VBA code to count Merged cells: Function CountCells(r As Range, s As String) As Integer CountCells=0 If Not r.Find(s) Is Nothing Then CountCells = r.Find(s).MergeArea.Cells.Count End Function