Hello
I dont want to use activecell.offset because everytime I add or remove table column I have to update the code
so how I say get vaule of
active cell
table1
coumn name "DATA"
note that activecell will be always inside the table
Hello
I dont want to use activecell.offset because everytime I add or remove table column I have to update the code
so how I say get vaule of
active cell
table1
coumn name "DATA"
note that activecell will be always inside the table
I guess you mean something like intersect(activecell.entirerow, activecell.listobject.listcolumns(data).range)
Rory
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks