Hide non-contiguous columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
No need to select

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Thanks, Bob.


Bob Phillips said:
No need to select

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
Click to expand...
 
Back
Top