I have a workbook with several columns that are not in use at this time. They all are labeled 'blank' in row 10.
Is there a way to automate hiding any column that contains 'blank' in row 10?
I appreciate any help.
I have a workbook with several columns that are not in use at this time. They all are labeled 'blank' in row 10.
Is there a way to automate hiding any column that contains 'blank' in row 10?
I appreciate any help.
Hi rcnowland
You can use this piece of Code to achieve what you are looking for.
Let me know if you get stuck.
Please Login or Register to view this content.
Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back
Please also mark your thread as solved once it has been.
Try this:
Please Login or Register to view this content.
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I think the OP means that row 10 contains the word "Blank", not that it is blank.
I added the work BLANK between the double quotes and it works great. Thanks so much.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks