troubleshooting Question
batch create smart tables on active worksheet
asked on
Dear Experts:
On the active sheet I would like to batch create smart tables using VBA.
ActiveSheet.ListObjects("T
The data on the active worksheet is organized as follows: 3 columns across and hundreds of rows that are divided intermittently by blank rows. The number of contiguously filled rows can vary greatly.
![batch_create_tables]()
I now would like to create hundreds of these smart tables ("TableStyleMedium9") on the active sheet automatically using a VBA Macro, ie. ...
... the macro is to detect each area where there are contiguously filled rows and create a smart table for them starting with the name 'tbl_001', then 'tbl_002' , ... tbl_455 etc. i.e. name them sequentially. There will be roughly 700, 800 smart tables after running the macro.
The smart tables all have a header row.
I hope this is feasible.
Help is very much appreciated. Thank you very much in advance. I have attached a sample file for your convenience.
Regards, Andreas
Batch_create_smart_tables.xlsx
On the active sheet I would like to batch create smart tables using VBA.
ActiveSheet.ListObjects("T
The data on the active worksheet is organized as follows: 3 columns across and hundreds of rows that are divided intermittently by blank rows. The number of contiguously filled rows can vary greatly.
I now would like to create hundreds of these smart tables ("TableStyleMedium9") on the active sheet automatically using a VBA Macro, ie. ...
... the macro is to detect each area where there are contiguously filled rows and create a smart table for them starting with the name 'tbl_001', then 'tbl_002' , ... tbl_455 etc. i.e. name them sequentially. There will be roughly 700, 800 smart tables after running the macro.
The smart tables all have a header row.
I hope this is feasible.
Help is very much appreciated. Thank you very much in advance. I have attached a sample file for your convenience.
Regards, Andreas
Batch_create_smart_tables.xlsx
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.