below code converts a defined range (B2:D8) into a table (using ListObject).
The code works just fine.
Is it possible to expand the macro to automatically convert several ranges into tables?
Naming convention is: Table1, Table2, Table3, etc.
The Ranges are not to be hard-coded but the code should detect these 'used ranges' automatically. Is this possible?
Help is much appreciated. Thank you very much in advance.
ActiveSheet.ListObjects.Add(xlSrcRange, Range("$B$2:$D$8"), , xlYes).Name = _
'No go in 2003
ActiveSheet.ListObjects("Table1").TableStyle = "TableStyleLight2"