JYool
New member
Is there a formula that can return the name of a table on a worksheet? or anything in VB? I'm using the =cell(filename) formula to isolate the name of the worksheet, but i can't find something similar to isolate the name of a table... but it's a property of that table, so it has to exist somewhere...
either that or can i force a table to be named based on a cell using a macro?
it's important that the table be validated to a list (either by stopping wrong entries, or by hilighting errors) but it's imperative that users can actually see the table name...
I'm pretty strong in excel, but somewhat inexperienced in the features of 2007+
either that or can i force a table to be named based on a cell using a macro?
it's important that the table be validated to a list (either by stopping wrong entries, or by hilighting errors) but it's imperative that users can actually see the table name...
I'm pretty strong in excel, but somewhat inexperienced in the features of 2007+