Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2014
176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. Selection.End(xlDown).Select
  2. Selection.End(xlDown).Select
  3. Selection.End(xlDown).Select
  4. Selection.End(xlToRight).Select
  5. ActiveCell.Range("A1:A33").Select
  6. Selection.AutoFill Destination:=ActiveCell.Range("A1:B33"), Type:= _
  7. xlFillDefault
  8. ActiveCell.Range("A1:B33").Select
  9. ActiveCell.Offset(1, 1).Range("A1:A32").Select
  10. Selection.Replace What:="[36 DRD BP-04_Apr 14.xlsx]", Replacement:= _
  11. "[37 DRD BP-04_May 14.xlsx]", LookAt:=xlPart, SearchOrder:=xlByRows, _
  12. MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  13. Selection.End(xlUp).Select
  14. Selection.End(xlUp).Select
  15. Selection.End(xlToLeft).Select
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement