Naming Excel tables from an Excel list.

[ztigges]

I have Excel workbooks with many worksheets that contain 100+ tables. I like to give my tables meanfuling names and not use the Excel generated names, but this is a tedious task. I would like to create a list of table names on an Excel worksheet and then be able to pull one of those names each time I create a new table. Is this possible? I am new to VBA and macros.

[patel45]

put names in column A from A2 to A4 then try this code

Please Login or Register  to view this content.

[HaHoBe]

Hi, patel45,

then be able to pull one of those names each time I create a new table

Your code does that?

Ciao,
Holger

[bsalv]

see attachment
Select your range that should be a table and run the macro "MakeMySelection..."

[HaHoBe]

Hi, bsalv,

nice sample, well done. But I would have used a Label instead of a Textbox for showing the explanatory text.

Ciao,
Holger

[bsalv]

ok, next time I'll do so. Thanks.

[ztigges]

Thanks everyone.

bsalv, I get a run-time error "A table cannot overlap another table". Any ideas?

[HaHoBe]

Hi, ztigges,

Any ideas?

Tables may not overlap if they are to have all the functions available - simple as that. Or you transfer the tables back to ranges where you loose the functions of a table. Your choice.

Ciao,
Holger