why i see all Table Names Greyed out in Name Manager even though these tables are on unprotected sheets. even if i create new table and check it on Name Manager it to is greyed out.
do suggest how to resolve this.. thanks
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Table Names greyed out in Name Manager
0
Answers
0
If the names are like Table1, Table2 etc., then these are names that get created when you convert a range to a Table. These can't be deleted or edit..
The only way to get rid of them is by converting the table back to a range.
Discussion
But I am not able to use table name as reference in Vba code...
I hv remamed the Tables too...
I hv remamed the Tables too...
hemantjshah Mar 14, '21 at 12:33 pm