hiding column using VB
 

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

hiding column using VB
 

Hi Associates,

Tty changing:

Worksheets("Data").Column("D:E").EntireColumn.Hidd en = True

to

Worksheets("Data").Column("D:E").EntireColumns.Hid den = True


(Note the final 's' in Columns)

---
Regards,
Norman



"associates" wrote
in message ...

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

hiding column using VB
 

Hi Associates,

Trying again(!)

Change:

Worksheets("Data").Column("D:E").EntireColumn.Hidd en = True

to

Worksheets("Data").Columns("D:E").EntireColumns.Hi dden = True


(Note the final 's' in Columns)


---
Regards,
Norman

hiding column using VB
 

Hi Associates,

I thought that I had omitted the final 's', but I now see that it was
inadvertently added to the second instance of 'Column'.

The correct syntax is:

Worksheets("Data").Columns("D:E").EntireColumn.Hid den = True


---
Regards,
Norman

hiding column using VB
 

Hi Norman,

Thank you for your reply.

Yes, it got rid of the error message there. Thanks for that

However, it doesn't hide the columns D and E.

Is there anything i missed out here?

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

hiding column using VB
 

Hi, Norman

Sorry, it works now. So please disregard my previous post.

Thank you for your help. :)


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