+ Reply to Thread
Results 1 to 2 of 2

Can you refer to ListObject Rows by "name"?

  1. #1
    Registered User
    Join Date
    09-25-2008
    Location
    Winnetka, CA
    Posts
    83

    Can you refer to ListObject Rows by "name"?

    I use ListObjects -- tables -- a lot. I know I can refer to a column by name, for instance:

    Please Login or Register  to view this content.

    But is there a similar way to refer to a row? I know the leftmost cell of a row isn't a "header", but is there an easy way to refer to a row based on what's in the first cell?

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London / Stockholm
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Can you refer to ListObject Rows by "name"?

    Not that I could figure out, Columns are different and are always unique. Maybe try,

    Please Login or Register  to view this content.
    where you change the lookup value (in blue) as needed. Will give you the first match in the first column. You could also use the find function as an alternative.

    Hope this helps.

    Cheers,
    berlan
    Last edited by berlan; 08-18-2015 at 06:44 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-25-2014, 06:55 AM
  2. MSO 2003 Excel- need formula to sum "every 6th row" of "E column" 6782 + rows deep
    By gerry@casi1986.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 08:43 PM
  3. Replies: 0
    Last Post: 11-22-2013, 01:36 PM
  4. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  5. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  6. Replies: 1
    Last Post: 09-21-2013, 03:18 AM
  7. [SOLVED] Expanded and collapsed the rows by toggle "+" or "-" sign on left of the text
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-24-2013, 02:49 PM
  8. How to refer "user's define reference" in a macro?
    By dusit_t in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2012, 02:18 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1