View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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