Thread
:
Hidding columns not working
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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 With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]