+ Reply to Thread
Results 1 to 2 of 2

VBA Code to Hide Columns that Don't Match Cell Values In a Drop Down List (35 cell range)

  1. 08-18-2020, 01:57 AM #1
    drakeyboii
    drakeyboii is offline
    Registered User
    Join Date
    08-18-2020
    Location
    AUS
    MS-Off Ver
    2013
    Posts
    5

    Question VBA Code to Hide Columns that Don't Match Cell Values In a Drop Down List (35 cell range)

    lnhhhhhhhhh
    Attached Images Attached Images
    Last edited by drakeyboii; 08-20-2020 at 02:13 AM.
    Reply With QuoteRegister To Reply
  2. 08-18-2020, 01:59 AM #2
    drakeyboii
    drakeyboii is offline
    Registered User
    Join Date
    08-18-2020
    Location
    AUS
    MS-Off Ver
    2013
    Posts
    5

    Re: VBA Code to Hide Columns that Don't Match Cell Values In a Drop Down List (35 cell ran

    To expand, I am trying to enable entries in all 30 something cells pictured above and have only the columns that match the text in the table to be unhidden in a separate sheet. Apologies for the terrible explanation but I am struggling massively.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide rows based on muti cell drop down list
    By prat33 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-06-2017, 09:32 PM
  2. Look Up To Columns, if Match The Same Values Paste to Relevant Cell Values to Another Cell
    By pvsvprasad in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-11-2016, 01:02 AM
  3. [SOLVED] Create drop down list with range of values that is exact match from a table
    By glenwalcuch in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-22-2015, 03:09 PM
  4. [SOLVED] How to hide columns whose cell do not match a specific value
    By excelnewbie84 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-01-2015, 09:29 AM
  5. Macro to delete entire rows if cell values do not match list/named range.
    By swolfe2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2013, 02:13 PM
  6. [SOLVED] Drop Down list range based on two different cell values
    By Jaywuzhere in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2012, 05:22 AM
  7. VBA code for (un)hide columns related to drop down list doesn't work
    By maumon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2010, 08:27 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1