Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
try
Sub hidecol() Set xlsSheet = Worksheets("Sheet2") xlsSheet.Columns("c").Hidden = True End Sub -- Don Guillett SalesAid Software wrote in message ups.com... xlsSheet = objWorkBook.Worksheets("Sheet1") xlsSheet.Range("C:C").EntireColumn.Hidden = True The program runs find loading all the data and calculating sums on the sheet but refuses to ever hide that column. What setting am I missing?? Thanks in adavance Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding columns | Excel Programming |