Convert Range to Table for a specific range in each selected sheet

[Wojtek1977]

Hello,

I would like to change this VBA code to be able to run it on selected sheets (looping) in one workbook but got stuck. (Ideally if the table name of each created table in each sheet =cell B3 of respective sheet (not a must though))
Help very appreciated.

Please Login or Register  to view this content.

Thank You!

[rorya]

Something like:

Please Login or Register  to view this content.

[Wojtek1977]

Something like:

Please Login or Register  to view this content.

Hi Rory,

It worked beautifully! Thank You so much!

One addition: would it be complicated to add a code so that there is no table formatting at all. My solution is to go to table design , go to table styles and choose the first one.. For I would prefer not to do it manually for 52 sheets. One way is to set this table style as default before running the macro but if there is a more elegant way , like adding a line to the code, it would be great.

[rorya]

Try this:

Please Login or Register  to view this content.

[Wojtek1977]

Fantastic, thank You so much!