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.
so i tried this:![]()
fCT = .Range("T" & Rows.Count).End(xlUp).Row
so what is the syntax for changing column "T" to "[@[Central Reviewer]]"![]()
set lst=activesheet.listobjects(1) with lst fct = .([@[Central Reviewer]] & Rows.Count).End(xlUp).Row msgbox "fct is " & fct end with
Bookmarks