Log In
Register
Home
Table Referencing Given the Cell Address
Jessica Stewart
Northern USA
Member
Members
Trusted Members
Trusted Members
Forum Posts: 202
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: 615
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: Andy Kirby, Scott Miller, Roy Lutke, Jeff Krueger, Kylara Papenfuss, Ivica Cvetkovski
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Ray-Yu Yang
George Shihadeh
Naomi Rumble
Uwe von Gostomski
Jonathan Jones
drsven
Forum Stats:
Groups: 3
Forums: 24
Topics: 6212
Posts: 27236
Member Stats:
Guest Posters: 49
Members: 31889
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —