Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. Sub test()
  2. '
  3. ' test Macro
  4. '
  5. ' Keyboard Shortcut: Ctrl+q
  6. '
  7. Range(Selection, Selection.End(xlToRight)).Select
  8. With Selection.Interior
  9. .Pattern = xlSolid
  10. .PatternColorIndex = xlAutomatic
  11. .Color = 65535
  12. .TintAndShade = 0
  13. .PatternTintAndShade = 0
  14. End With
  15. Selection.End(xlToRight).Select
  16. Range("G2").Select
  17. Range(Selection, Selection.End(xlToRight)).Select
  18. Selection.Insert Shift:=xlDown
  19. Range("F2").Select
  20. Selection.ClearContents
  21. Range("F2").Select
  22. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement