Hide non-contiguous columns

[Guest]

Greetings:
Have for some time used the following in a number of applications
Columns("F:G").Select
Selection.EntireColumn.Hidden = True
Works Great:
Now I need to add column J, as well.
After checking group sites, I tried:
Columns("F:G,J").Select
Columns("F:G,J:K").Select
etc................. .
F and G always hides fine
J (and K) are to stubborn to disappear.

Then I read in one post to use "Select" as little as possible, so I changed to
Range("F:G,J:K").EntireColumn.Hidden = True
and variations thereof.
Again, F and G disappear, J and K just keep hanging around.

Once again, I'm likely missing something obviouis, but I just can't find it.
Please help.

ALSO: Why is it recommended to be good coding practice to use SELECT as
infrequently as possible?

Thanks

 

[Bob Phillips]

No need to select

Range("F:G,J:L").EntireColumn.Hidden = False


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks, Bob.

No need to select

Range("F:G,J:L").EntireColumn.Hidden = False


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)