I'm trying to iterate through a range of merged cells, but each cell in the merged row is being iterated through and I want it to go from row to row.
This what I have, but the subscript goes out of range since is looking at the cells within the merged rows.
Public Sub PostSupers(ByRef rngSupers As Range, ByRef strarySupers() As String)
Dim intSuper As Integer
Dim Super As Range
intSuper = 0
For Each Super In rngSupers
Super.Value = strarySupers(intSuper)
intSuper = intSuper + 1
Next Super
End Sub
Bookmarks