Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display columns
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display columns alphabetically | New Users to Excel | |||
Compare columns and display the value | Excel Discussion (Misc queries) | |||
display only columns A to I | Excel Programming | |||
Scrolling columns display | Excel Programming | |||
compare two columns and display a third | Excel Discussion (Misc queries) |