ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hide columns by column number (https://www.excelbanter.com/excel-programming/379396-hide-columns-column-number.html)

Gary Keramidas

hide columns by column number
 
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




Gary Keramidas

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







All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com