How to border multiple tables in an excel file where number of columns to each table changes

[Praw1n (PRAVEEN KUMAR MANDADI)]

Hello Friends,

I want to border the multiple tables in an excel file where each table has unique column names and count of the columns for each table will not be same.
I will get the datatables dynamically where number of rows of each table might differ.

How can I border the each table. Please help me…

[stary (Stanislaw R)]

First, I would write a VBA code to get top left cells for each table. Next I would again use VBA to get range of each table. Once, you got a range, you can easily make a borders.

[lrtetala (Lakshman Reddy)]

Hi, you can try this

This is the Output

[Praw1n (PRAVEEN KUMAR MANDADI)]

@lrtetala
It worked for me…
But it is taking more time to border the tables because I have more than ten tables.

Is there any other way.