View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Macro to Hide columns

Sub Macro()
Range("G1,H1,U1,AC1,AE1").EntireColumn.Hidden = True
'OR
'Range("G:G,H:H,U:U,AC:AC,AE:AE").Columns.Hidden = True
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"whatzzup" wrote:

Good afternoon,
I am trying to create a macro to hide certain columns on a spreadsheet, how
best do i do this, say want to hide columns g, h, u, ac & ae