› ›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Facebook Sign In with Google Sign In with OpenID
Sign In Register

Categories

We have migrated to a new platform! Please note that you will need to reset your password to log in (your credentials are still in-tact though). Please contact lee@programmersheaven.com if you have questions.
Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Excel VBA Hiding a Column

rrfullirrfulli Posts: 1Member
in VBA
I am looking for a method to hide a selected column using VBA in excel. To select a column I:

Worksheets("Sheet1").Columns(1).Select

That's as far as I get. The column is now selected. How do I hide the selected column??????

Thanks
Ranny
Flag · Vote Down Vote Up ·

Comments

  • markycmarkyc Posts: 11Member
    Hey Ranny,

    With any kind of simple task you can use the macro recorder in order to automatically generate the code for you:
    ie:

    Columns("I:I").Select
    Selection.EntireColumn.Hidden = True

    In general you just set the EntireColumn.Hidden property to True or False to hide/unhide a particular column.
    Columns("I:I").EntireColumn.Hidden = True

    Ciao,
    Mark


    : I am looking for a method to hide a selected column using VBA in excel. To select a column I:
    :
    : Worksheets("Sheet1").Columns(1).Select
    :
    : That's as far as I get. The column is now selected. How do I hide the selected column??????
    :
    : Thanks
    : Ranny
    :

    Flag · Vote Down Vote Up ·
Sign In or Register to comment.