+ Reply to Thread
Results 1 to 3 of 3

Automatically hide columns and unhide of cell value(s) appear within a range

  1. #1
    Registered User
    Join Date
    12-27-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    11

    Automatically hide columns and unhide of cell value(s) appear within a range

    Hi, being a novice to VBA and these forums, apologies in advance for any confusion or improper posting.

    I have a spreadsheet with Column C that has cells 19 -100 that are dropdown cells that allow you to pick one of 8 currencies (US$, GBP, A$, EUR... etc)

    I have columns M to T, eahc of which contains data corresponding to one of those currencies (ie M = US$ info, N = GBP info, etc)

    I want all of M:T hidden, unless at least one of the cells in C:19 to C:100 selects one of those currencies, in which case I want the corresponding column(s) unhidden. For example, if C:19 selects US$ then I want to show column M, and also if C:20 selects A$, then I want column O unhidden. Right now all are hidden and only the most recent one selected, regardless of which cell in column C, is unhidden (meaning if I select C19 as US$ the US column becomes unhidden, but then if I select A$ in another cell in the range, US$ becomes hidden again and A$ column unhides). Can anyone help?

    I'm attaching sample code (I only included US$, GBP, and A$ for simplicity until I figure this out)

    Thanks

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,576

    Re: Automatically hide columns and unhide of cell value(s) appear within a range

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-27-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Automatically hide columns and unhide of cell value(s) appear within a range

    Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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