Prezados,
mensalmente eu extraio um relatório do EBTA e tentei fazer uma macro para que formatasse de acordo com os requisitos, porém não está indo, podem me ajudar a achar o erro?
Sub Baseinfo()
'
' Baseinfo Macro
'
While Range("A2").Value <> ""
Range("A2").Select
Selection.Cut
Sheets("Plan2").Select
Range("A2").Select
ActiveSheet.Paste
Sheets("Plan1").Select
Range("A3").Select
Selection.Cut
Sheets("Plan2").Select
Range("B2").Select
ActiveSheet.Paste
Sheets("Plan1").Select
Range("A4").Select
Selection.Cut
Sheets("Plan2").Select
Range("C2").Select
ActiveSheet.Paste
Range("A5").Select
Selection.Cut
Sheets("Plan2").Select
Range("D2").Select
ActiveSheet.Paste
Range("A6").Select
Selection.Cut
Sheets("Plan2").Select
Range("E2").Select
ActiveSheet.Paste
Range("A7").Select
Selection.Cut
Sheets("Plan2").Select
Range("F2").Select
ActiveSheet.Paste
Range("A8").Select
Selection.Cut
Sheets("Plan2").Select
Range("G2").Select
ActiveSheet.Paste
Range("A9").Select
Selection.Cut
Sheets("Plan2").Select
Range("H2").Select
ActiveSheet.Paste
Range("A10").Select
Selection.Cut
Sheets("Plan2").Select
Range("I2").Select
ActiveSheet.Paste
Range("A11").Select
Selection.Cut
Sheets("Plan2").Select
Range("J2").Select
ActiveSheet.Paste
Rows("2:2").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Sheets("Plan1").Select
Range("A2:A11").Select
Selection.Delete Shift:=xlUp
Wend
End Sub
Postado : 23/11/2015 12:48 pm