Hiding columns in excel

[mccabecliona]

Hello
I have a spreadsheet with about 300 columns and on one row the value is either 'PRINT' or 'DON'T PRINT' - I need to hide the columns with the 'DON'T PRINT' value. PLEASE.... BTW I have never used a macro before ... so I would really need Noddy and Big Ears instructions. Thanks cli

[JieJenn]

Can you provide a sample Excel file that represent what your Excel sheet is going to look like?

[Olly]

Press Alt-F11 to open the Visual Basic Editor.

Click Insert > Module.

In the module which is created, paste the following code, and change the lRow and sHide values to suit your requirement:

Please Login or Register  to view this content.

Close the Visual Basic Editor to return to Excel.

Press Alt-F8, select "HideColumnsByValue" and click "Run"


If you want to show all columns again, you could add this code to the module in the Visual Basic Editor, and run the macro "UnhideAllColumns":

Please Login or Register  to view this content.

[mccabecliona]

Hi
I can't figure out how to attach the spreadsheet .....

[mccabecliona]

oh apparently I did figure it out ....

[daboho]

You can using manipulate

Please Login or Register  to view this content.

[mccabecliona]

THANK YOU ... THANK YOU ... THANK YOU
cli

[Olly]

Who are you thanking - which solution worked for you?

[mccabecliona]

Hi
Apologies - the suggestion from JieJenn worked perfectly.
Tks
Cli

[Olly]

I don't see a solution from JieJenn, only a suggestion to attach your workbook?

[bsesender]

i would like some help hiding columns as well, do i need to start my own thread?

i export a monthly report to excel and need to hide the same columns each month. can this be made easier? i need to hide c:r, v:z, and ae:av
what is the easiest way to do this? step by step please formula, vba, macro... but i am a beginner..

[Olly]

i would like some help hiding columns as well, do i need to start my own thread?

Yes.



Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.