Hello
I have set of queries tables in same sheet in same columns range
Looking to have code in sheet activate event after refresh all queries to add title for each table and formatting:
1 - for each table in sheet, add one row above the table header
2 - Write in the new row, the name of the table in excel
3 - formatting the new row, merge B:D and text alignment center across selecting, Black Bold font, row height 30
there is result sample in the attachment
note: the code should work even if I add or delete a table
Bookmarks