Log In
Register
Home
Table Referencing Given the Cell Address
Jessica Stewart
Northern USA
Member
Members
Trusted Members
Trusted Members
Forum Posts: 219
Member Since:
February 13, 2021
February 13, 2021
Offline1
December 30, 2021 - 9:00 am
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.
See Answer
Velouria
London or thereabouts
Moderator
Members
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 832
Member Since:
November 1, 2018
November 1, 2018
Offline2
December 30, 2021 - 9:06 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. 😉
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 919
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 339
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Michael Denton
Nick Pascal
David Webb
Johannes Bruentrup
John Jay
Larry Silverman
David Rousseau
Melinda Heidemann
Jose Fuentes
Abigail Hernandez
Forum Stats:
Groups: 3
Forums: 25
Topics: 7072
Posts: 30993
Member Stats:
Guest Posters: 49
Members: 34469
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —