Hi,

How do i hide columns in worksheets?

I have the following code,
Private Sub CM_Filtergroup_Click()
Beep
' clears the formulas and formatting in cells A1:G37 on "Data"
Worksheets("Data").Unprotect
Worksheets("Data").Range("A1:S200").Clear
Worksheets("Data").Column("D:E").EntireColumn.Hidd en = True
ImportCSVgroup
End Sub

The above code gives me an error message saying

runtime error '438'
Object doesn't support this property or method

Need your help.

Thank you in advance


--
associates
------------------------------------------------------------------------
associates's Profile: http://www.excelforum.com/member.php...o&userid=35073
View this thread: http://www.excelforum.com/showthread...hreadid=548469