Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidding columns not working
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidding columns not working
Ryan
I think tht you need to use set, see below. Set objWorkBook = ActiveWorkbook Set xlsSheet = objWorkBook.Worksheets("Sheet1") xlsSheet.Range("C:C").EntireColumn.Hidden = True This is a slightly neater way of achiveing the same result. xlsSheet.Columns("C").Hidden = True |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidding columns not working
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |