February 13, 2021
Given a cell address is there a way to find out what column it is in on the table?
For clarification: I have VBA looking for content in the cells on two table on a worksheet. Once there, I'll need to offset the reference but the content could be in either of two columns on either of the two tables. Once my macro has found my cell, is there a way to tell what column it displays in? I already figured out how to tell what table my cell is on.
November 1, 2018