View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Hellotalktome13@hotmail.com is offline
external usenet poster
 
Posts: 1
Default 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