how to use a table column name instead of the column name so replace range with listobject

im working on this post and this is the question that i have.

how can i refer to a column name based on its table column name and not a column letter. this is the syntax that i have that needs to get replace.

Please Login or Register  to view this content.

so i tried this:

Please Login or Register  to view this content.

so what is the syntax for changing column "T" to "[@[Central Reviewer]]"

ok so first thanks for the links, i have frequented them as of late. but it always helps to refresh.

so i changed this line:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

so all his code did for this variable was find the last row in t. unfortunately mine give the last row in the table. how to make it look at column t's table column name?

so how can i use the listobject to find the last cell that has data in the table based on its column name?

also what is the syntax for finding the value of a cell in a table based on it's row?

thanks first of all for commenting on this thread. but it seems that this last edit (to the OP's source code, thread found here), is beyond me. can you look at this thread and see if there is an easy way to code this for table column names? i ask cause i can use this functionality in some of my existing macros.

can you take a look at dangerdavesp's post? I dont know how to make his last request work, need a guru like you to fix.

thanks

here is dave's new post