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

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

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