Hi

For instance: Range("A1,C1,F1").EntireColumn.Hidden = True

But a small loop is not so inefficient in this case.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"mwam423" wrote:

greetings, i have macro which runs query on database with over 100 columns.
when macro is finished i want to display only those columns i've run the
query on, anywhere from two to twenty columns.

therefore i hide all the columns of database and have a range which lists
each column to display by number (col A =1, col B = 2, etc.) what type of
code would i use to display the columns.

have used "EntireColumn.Hidden = false" but only seems to work for single
column at a time, which would work with a loop. but i'm hoping there's some
code that would unhide all the columns at once, any help greatly appreicated.