juliencoquet

Google Analytics days of week Excel replace macro

Mar 4th, 2013
294
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub replaceDaysOfWeek()
  2. '
  3. ' replaceDaysOfWeek Macro
  4. ' Replace day identifiers (0-6) with day labels (Sun-Sat)
  5. '
  6.    Cells.Replace What:="0", Replacement:="Sun", LookAt:=xlWhole, _
  7.         SearchOrder:=xlByColumns, MatchCase:=False
  8.     Cells.Replace What:="1", Replacement:="Mon", LookAt:=xlWhole, _
  9.         SearchOrder:=xlByColumns, MatchCase:=False
  10.     Cells.Replace What:="2", Replacement:="Tue", LookAt:=xlWhole, _
  11.         SearchOrder:=xlByColumns, MatchCase:=False
  12.     Cells.Replace What:="3", Replacement:="Wed", LookAt:=xlWhole, _
  13.         SearchOrder:=xlByColumns, MatchCase:=False
  14.     Cells.Replace What:="4", Replacement:="Thu", LookAt:=xlWhole, _
  15.         SearchOrder:=xlByColumns, MatchCase:=False
  16.     Cells.Replace What:="5", Replacement:="Fri", LookAt:=xlWhole, _
  17.         SearchOrder:=xlByColumns, MatchCase:=False
  18.     Cells.Replace What:="6", Replacement:="Sat", LookAt:=xlWhole, _
  19.         SearchOrder:=xlByColumns, MatchCase:=False
  20. End Sub
Add Comment
Please, Sign In to add comment