View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default hide columns by column number

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

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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