Notifications
Clear all
VBA & Macros
3
Posts
2
Users
0
Reactions
123
Views
Topic starter
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.
Posted : 30/12/2021 7:00 pm
You can work out the offset between the cell's Column property and the Listobject.Range.Column, which will tell you the listcolumn number. From there you can get whatever info you need. 😉
Posted : 31/12/2021 7:06 am
Topic starter
Thank you so much!
Posted : 31/12/2021 11:10 am
