Quote Originally Posted by jazz2409 View Post
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?