If columns are not specific ones then hide them

  • Try this


    Code
    Dim colls As Range
        'A, D, M, CX
        Set colls = Range("A1,D1,M1,CX1").EntireColumn
        Cells.Columns.EntireColumn.Hidden = True
        colls.Hidden = False
  • Assuming you have headers in row 1, try:

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!