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
Bookmarks