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: 688
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: Philip Treacy, Nicholas Meyer, QSolutions Group
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Herbie Key
Trevor Pindling
Stevan Kanjo
Erin Sheldon
Nikita Bhatia
Sheilah Taylor
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Forum Stats:
Groups: 3
Forums: 24
Topics: 6526
Posts: 28576
Member Stats:
Guest Posters: 49
Members: 32809
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —