Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort Contiguous Columns - Danger | Excel Discussion (Misc queries) | |||
Charting with non contiguous columns | Charts and Charting in Excel | |||
DCOUNT for non-contiguous columns | Excel Worksheet Functions | |||
How do I reference non-contiguous columns in another sheet and th. | Excel Discussion (Misc queries) | |||
Is there a maximum number of non-contiguous columns that can be h. | Excel Discussion (Misc queries) |