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