Skip to content

Instantly share code, notes, and snippets.

@tidusx18

tidusx18/format_pageviews_csv.vba

Created March 26, 2019 17:17
Show Gist options
  • Save tidusx18/c7f41346c628afacc382feb25bd07091 to your computer and use it in GitHub Desktop.
Save tidusx18/c7f41346c628afacc382feb25bd07091 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
format_pageviews_csv.vba
Sub format_pageviews_csv()
With ActiveWorkbook.ActiveSheet.Range("A1:B1, J1, L1:M1, P1:Q1, S1").EntireColumn
.Delete
End With
ActiveWorkbook.ActiveSheet.Range("B1:K1").EntireColumn.AutoFit
ActiveWorkbook.ActiveSheet.Range("A1").EntireColumn.ColumnWidth = 140
With ActiveWorkbook.ActiveSheet.Range("A1:k1")
.Font.Bold = True
.AutoFilter
End With
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment