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

[dmcgov]

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]]"

[AlphaFrog]

Here are two good resources for VBA syntax with tables.

Working With Tables In Excel 2013, 2010 And 2007 (VBA)

The VBA Guide To ListObject Excel Tables



You probably don't need the .End(xlUp) part when using a Table, though I don't know what ultimately you want to do.

This will select a column By header name

Please Login or Register  to view this content.

[dmcgov]

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?

[AlphaFrog]

The table column header is "Central Reviewer"

fCT is the row number of the last used cell in the column

fCTValue is the value of the last used cell in the column

Please Login or Register  to view this content.

[dmcgov]

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.

[dmcgov]

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

[dmcgov]

here is dave's new post