+ Reply to Thread
Results 1 to 2 of 2

Select column based on column header name

  1. #1
    Forum Contributor
    Join Date
    08-23-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    404

    Select column based on column header name

    Hi all,

    I have an Excel table. One of the column headers is called "Test". How do I select the whole column where 'Test' is? (the whole column - not just the table column)

    Thanks

  2. #2
    Forum Contributor
    Join Date
    08-23-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    404

    Re: Select column based on column header name

    Sorted it myself. It's amazing what writing the problem out does.

    The below will hide the column (rather than select it) as that is what I was trying to get to.

    Please Login or Register  to view this content.

+ 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. Return column header based on column criteria and number value
    By bwill22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2014, 07:33 PM
  2. Replies: 1
    Last Post: 01-30-2014, 01:42 PM
  3. Range Select Based on Column Header
    By Nospmas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2013, 11:27 AM
  4. [SOLVED] Returning all the values in a column based on the column header
    By Benisato in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2012, 11:19 AM
  5. Replies: 1
    Last Post: 01-30-2009, 07:40 PM

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