Autohide Specific Columns

[crayzayone]

I work with a specific spreadsheet daily... This spreadsheet is sent as a "new" spreadsheet each day to my email (company policy, even if it is slightly moronic lol) but since that is the case, I have to format each spreadsheet daily to get rid of the data I don't really need. I would appreciate if anybody can possibly think of a way I can AutoHide these columns without manually CTRL Click or Shift Clicking groups. I was thinking Macros, but I know that the macro wouldn't be saved on the new day's document. But these are the columns I need hid:

A/C/E-H/J-N/P-V/X-AB/AF-AU/BA-BX/CB-CL/CN-DO/DR-DX

 

[Smitty]

Welcome to the Board!

You can record a macro and choose to store it in your "Personal Macro Workbook". That way it will be available to call from any instance of Excel. You can also assign it a keyboard shortcut, just make sure not to assign a given key (like CTRL+Z)!

HTH,

 

[crayzayone]

Welcome to the Board!

You can record a macro and choose to store it in your "Personal Macro Workbook". That way it will be available to call from any instance of Excel. You can also assign it a keyboard shortcut, just make sure not to assign a given key (like CTRL+Z)!

HTH,

Thank you! I appreciate the swift response... As I only know enough about creating macros to really screw them up, I'm really looking at macros from other posts that may be beneficial and trying to edit them for my use. for instance:

Option Explicit

Sub HideColumns(a,c,e:h,j:n,p:v,x:ab,af:au,ba:bx,cb:cl,cn:do,dr:dx)
Dim rng As Range
Dim c As Range

For Each c In Sheets("Sheet1").Range("G1:Z1")
If Len(c) = 0 Then
If rng Is Nothing Then
Set rng = c
Else
Set rng = Union(rng, c)
End If
End If
Next c
rng.EntireColumn.Hidden = True
End Sub

I found that code on another post and edited the ranges (I honestly don't know if that will even work lol that's how ignorant I am). All i want it to do is hide those specific columns, I don't need it to do anything else. I'm not sure what the "For each c in Sheets" part and below does but I didn't want to mess up the code so... If you could clarify I would appreciate it.

 

[Smitty]

Did you try recording a macro hiding those columns?

That will give you the code you need.