LinkBack URL
About LinkBacks
Hello
I'd like to hide columns from C to Z that do not contain the same word shown in cells A3, A4 or A5. I am familiar with providing the necessary button to run the code.
can anyone give me any suggestions?
Many thanks.
Hello
I'd like to hide columns from C to Z that do not contain the same word shown in cells A3, A4 or A5. I am familiar with providing the necessary button to run the code.
can anyone give me any suggestions?
Many thanks.
Did you mean the column headers in row 1 don't contain the three values? If yes, then try something like this...
Please Login or Register to view this content.
Last edited by AlphaFrog; 01-20-2015 at 09:29 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hello
In column A, I have several cells, currently A3, A4 and A5 (and may have a few more) that could contain a word matching a cell or cells in columns C to Z. What I need is all columns from C to Z that do not contain a word matching any cell in Column A, to be hidden.
Thanks again.
Originally Posted by Garysmith
Please Login or Register to view this content.
Great
I swapped the .Hidden = "true" and "false" around and it does exactly what I need.
Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks