Pessoal,
como posso dar continuidade a essa macro para que ela continue executando até parar numa célula vazia?
Sheets("Plan1").Select
Range("A2").Select
Selection.Copy
Range("C1").Select
ActiveSheet.Paste
Rows("2:2").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
Range("C1").Select
Selection.Copy
Sheets("dados").Select
Range("A2").Select
ActiveSheet.Paste
Range("A4").Select
Range("A4:I5000").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("A1:I2"), Unique:=False
Columns("L:L").Select
Selection.ClearContents
Range("A4").Select
Sheets("Plan1").Select
Range("D3").Select
Postado : 19/08/2014 1:53 pm