Hi,
Can anyone advise to help fix the below?
In Column F , G, and H (merged cells) there are multiple occurrences of the word "** Conclusion". What I would like to do is when each occurence is found, merge the two cells next to the occurence (columns I and J) and also merge the two cells next to the that (Columns K and L)
I have the following code, but I can't even get it to merge the two cells next to the first occurence of "** Conclusion" correctly
Thanks!![]()
For Each cell In Range("F5:H" & Range("F" & Rows.Count).End(xlUp).Row) If cell = "** Conclusion" Then Range(ActiveCell.Offset(0, 1), ActiveCell.Offset(0, 2)).Select With Selection .MergeCells = True End With End If Next cell
Bookmarks