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

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…

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.

Hi, you can try this

This is the Output

1 Like

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.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.