Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. Range("A" & (ActiveCell.Row)).Copy ("H2")
  2.  
  3. Range("H2").value = Cells(ActiveCell.row, 1).value
  4.  
  5. Range("A" & (ActiveCell.Row)).Copy Destination:=Range("H2")
  6.  
  7. Option Explicit
  8.  
  9. Public Sub tmpSO()
  10.  
  11. Dim ws As Worksheet
  12.  
  13. Set ws = ThisWorkbook.ActiveSheet
  14. ws.Range("A" & (ActiveCell.Row)).Copy Destination:=ws.Range("H2")
  15.  
  16. End Sub
  17.  
  18. Range("A" & (ActiveCell.Row)).Copy [H2]
  19.  
  20. Range("A" & (ActiveCell.Row)).Copy Range("H2")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement