
Originally Posted by
jazz2409
How do I add a table at the end of the very last table? This table has different headers than the ones for Sub LOB. I tried to do the same as the Overall Table but it's either:
1) being added after every table per sheet
2) being added just after the last table of the very last sheet
Also, is there a way to merge two cells of a table?
End With
If cll.Offset(1).Value <> CurrentCat Then
NewSht.Cells(Rows.Count, "B").End(xlUp).Offset(2).Select
MsgBox "Code for new table at selected cell here"
End If
Next Cll
New code in blue.
Merging: Yes; which cells, and why?