troubleshooting Question

batch create smart tables on active worksheet

Avatar of Andreas Hermle
Andreas HermleFlag for Germany asked on
Microsoft OfficeMicrosoft ExcelVBA
5 Comments1 Solution102 ViewsLast Modified:
Dear Experts:

On the active sheet I would like to batch create smart tables using VBA.
ActiveSheet.ListObjects("Tabelle1").TableStyle = "TableStyleMedium9"

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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
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.

-Mike Kapnisakis, Warner Bros