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

Help Studio
, , , ,
1

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…

2

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.

3

Hi, you can try this

Excel Table
Excel Table731×673 20.8 KB

This is the Output

Excel File
Excel File485×544 9.81 KB

1 Like
4

@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.

5

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