Count Merged Cells In Excel - Solution!

00:00 - Intro to Merged Cells
01:04 - Add Developer tab to ribbon
01:48 - VBA code to count Merged Cells
05:34 - Testing VBA code
You can encourage me by subscribing to my channel, sharing my content and by being a regular viewer.
Link to the channel - / @aggshruti1

[@AggShruti1]

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