+ Reply to Thread
Results 1 to 2 of 2

Read Table Headers to Array

  1. #1
    Forum Contributor
    Join Date
    03-22-2012
    Location
    OR, USA
    MS-Off Ver
    Excel 14/2010
    Posts
    273

    Read Table Headers to Array

    I have a table with headers where I want to read where if the cells, in a row by name, under the columns are notated with an X. For each the X exists then the header is placed into the combobox.

    So if C2 (hospital name) matches a name in the array the row is read for an X. Then if an X exists the column header is placed into the combobox.list.

    Code below and file attached.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Read Table Headers to Array

    Hi lloydgodin

    I'm not certain why you wish to write all that stuff to an array...here's a different approach that seems to work.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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: 1
    Last Post: 06-27-2016, 07:45 AM
  2. How to read headers from closed file and paste it in new sheet as column using VBA
    By Amar321 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2016, 04:09 AM
  3. autofilter method of range class failed -header has tables headers and non table headers
    By naveen.acheanz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2016, 08:21 AM
  4. [SOLVED] Read last element of Split array and then discard it and resize the array.
    By staggers47 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-28-2012, 06:36 PM
  5. Replies: 2
    Last Post: 05-09-2012, 01:30 PM
  6. Read Range To Array, Then Pass Array To Function
    By ProbablyNotARealName in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2010, 12:29 PM
  7. ActiveX script to read in column headers from Excel
    By Andy S. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2005, 12:05 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