[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

hide columns by column number

Gary Keramidas

12/14/2006 5:21:00 AM

figured i'd start a new thread

how do i hide a range of columns using column numbers?

something like:
columns(7,10).hidden = true

rows work like this, why not columns
rows("1:2").select

--


Gary



1 Answer

Gary Keramidas

12/14/2006 5:26:00 AM

0

i found a way
Range(Columns(firstCol), Columns(endCol)).Hidden = False

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:ugi0V%23zHHHA.1276@TK2MSFTNGP04.phx.gbl...
> figured i'd start a new thread
>
> how do i hide a range of columns using column numbers?
>
> something like:
> columns(7,10).hidden = true
>
> rows work like this, why not columns
> rows("1:2").select
>
> --
>
>
> Gary
>
>
>