Hide Columns

B

Boller

Banned

Joined

Apr 11, 2006

Messages

2,328

• Apr 25, 2011

• #2

I think you should be able to do this with the macro recorder.

Just record :- the required filter on column F and the hiding of all columns except C, D, and F.

 

Upvote 0

M

mathsbeauty

Board Regular

Joined

Apr 23, 2011

Messages

89

• Apr 25, 2011

• #3

Hello Boller! Actually I want to learn this for something more general. I need this macro to be used on various worksheets containing different columns. So recording may not help. Thanks for your suggestion.

 

Upvote 0

J

jasonb75

Well-known Member

Joined

Dec 30, 2008

Messages

15,509

Office Version

1. 365

Platform

1. Windows

• Apr 25, 2011

• #4

Recorded or written, it would still be specific to those exact criteria.

If you want something flexible then you need to include criteria to identify the columns as the correct ones to show / hide.

 

Upvote 0

M

mathsbeauty

Board Regular

Joined

Apr 23, 2011

Messages

89

• Apr 25, 2011

• #5

Hello Jasonb75! Is there any way in which we can identify all other columns except few specified in excel? e.g. Is it possible to write a macro which only shows column F and all other are hidden? By all other I mean that the only one column is shown, even blank columns are hidden.

 

Upvote 0

J

jasonb75

Well-known Member

Joined

Dec 30, 2008

Messages

15,509

Office Version

1. 365

Platform

1. Windows

• Apr 25, 2011

• #6

That is easily done, but you still need to decide how you're going to 'specify' the few exceptions.

Also, is it always "No" to be hidden in column F? If not, again you need a way to define how to choose the correct criteria.

 

Upvote 0

B

Boller

Banned

Joined

Apr 11, 2006

Messages

2,328

• Apr 25, 2011

• #7

mathsbeauty said:

Hello Boller! Actually I want to learn this for something more general. I need this macro to be used on various worksheets containing different columns. So recording may not help. Thanks for your suggestion.

Click to expand...

This requirement is a lot different from your original post.

If you really want to learn VBA, start by recording what you want based on your original post and then learn from the code that is produced.

If you cannot then adjust the code obtained to fit your general requirements, post again

 

Upvote 0

J

jasonb75

Well-known Member

Joined

Dec 30, 2008

Messages

15,509

Office Version

1. 365

Platform

1. Windows

• Apr 25, 2011

• #8

What you asked for would be something like

Code:

Sub test()
    Cells.EntireColumn.Hidden = True
    Range("C:D", "F").EntireColumn.Hidden = False
    ActiveSheet.[F1].AutoFilter Field:=1, Criteria1:="<>no"
    Application.Goto [a1]
End Sub

although I'm not convinced that what you really want will be anywhere near that.

 

Upvote 0

B

Boller

Banned

Joined

Apr 11, 2006

Messages

2,328

• Apr 25, 2011

• #9

jasonb75 said:

What you asked for would be something like

Code:

Sub test()
    Cells.EntireColumn.Hidden = True
    Range("C:D", "F").EntireColumn.Hidden = False
    ActiveSheet.[F1].AutoFilter Field:=1, Criteria1:="<>no"
    Application.Goto [a1]
End Sub

although I'm not convinced that what you really want will be anywhere near that.

Click to expand...

Which is what he could get from the macro recorder.

 

Upvote 0

M

mathsbeauty

Board Regular

Joined

Apr 23, 2011

Messages

89

• Apr 25, 2011

• #10

Sorry, Bollard. It does not work. Thanks for your efforts.

 

Upvote 0