Advertisement
Guest User

Untitled

a guest
Jul 15th, 2019
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. // My first macro!
  2.  
  3. Sub Botón2_Haga_clic_en()
  4. a = Worksheets("Hoja1").Cells(Rows.Count, 1).End(xlUp).Row
  5.  
  6. For I = 1 To a
  7.  
  8. If Worksheets("Hoja1").Cells(I, 1).Interior.ColorIndex = 3 Then
  9.  
  10. Worksheets("Hoja1").Rows(I).Copy
  11.  
  12. Worksheets("Hoja2").Activate
  13.  
  14. b = Worksheets("Hoja2").Cells(Rows.Count, 1).End(xlUp).Row
  15.  
  16. Worksheets("Hoja2").Cells(b + 1, 1).Select
  17.  
  18. ActiveSheet.Paste
  19.  
  20. Worksheets("Hoja1").Activate
  21.  
  22. Worksheets("Hoja2").Cells(b + 1, 1).Interior.ColorIndex = xlNone
  23.  
  24. End If
  25.  
  26. Next
  27.  
  28. Application.CutCopyMode = False
  29.  
  30. ThisWorkbook.Worksheets("Hoja1").Cells(1, 1).Select
  31.  
  32. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement