How to hide multiple sets of columns in VBA?

Question

I would like to hide certain columns when a macro is run. How do I do this?

I know how to do it by a range of columns ("B:D") using:

Columns("B:D").EntireColumn.Hidden = True

But I'm not sure how to specify multiple columns that are not next to each other.

I would need to hide columns: B, C, F, G, I, J, K, L, N.

Record Macro gives very good hints. It will result in something like the answer below, but with the correct ,N:N at the end — Slai
– Slai, Commented Nov 18, 2016 at 22:25
Thanks @Slai - I hadn't noticed that the "N" by itself wouldn't be a valid range specification. — YowE3K
– YowE3K, Commented Nov 18, 2016 at 22:47

YowE3K · Accepted Answer · 2016-11-18 22:46:00Z

13

Range("B:C,F:G,I:L,N:N").EntireColumn.Hidden = True

(Edited to fixed the bug noticed by Slai - have to have "N:N" and not just "N".)

answered Nov 18, 2016 at 22:06

YowE3K

24k7 gold badges28 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

use ``` Columns(col0 & ":" & col1).Hidden = TRUE``` instead, 'entireColumn' for some reason is super slow