ERRO EM TEMPO DE EXECUÇÃO 1004

wgama

08-03-2018 15:25:10

BOM DIA

tenho duas planilhas aonde o usuário insere vários dados em uma delas clica em um botão e determinados dados desta planilha são automaticamente transferidos para a próxima linha vazia da outra planilha, quando criei o código funcionava perfeitamente mais quando fechei os arquivos e abri novamente começou a dar este erro:

erro em tempo de execução 1004
erro de definição de aplicativo ou de definição de objeto

Private Sub CommandButton1_Click()


Workbooks.Open Filename:= _
"L:\ARMAZEM RECEBIMENTO\ARMAZEM RECEBIMENTO\resumo.xlsx"
Sheets("Plan1").Select




Windows("ROMANEIO GERAL.xlsm").Activate
Range("C5:J5").Select
Selection.Copy

Windows("RESUMO.xlsx").Activate
' Worksheets(1).Range("A3").SelectSelect
Worksheets(1).Range(Rows.Count, 1).End(xlUp).Offset(1, 0).Activate
' Worksheets(1).Range("A3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

' Worksheets(1).Range("B3").Select
Windows("ROMANEIO GERAL.xlsm").Activate
ActiveWindow.SmallScroll Down:=3
Range("D25:G25").Select
Application.CutCopyMode = False
Selection.Copy

Windows("RESUMO.xlsx").Activate
Worksheets(1).Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

'Worksheets(1).Range("C3").Select
Windows("ROMANEIO GERAL.xlsm").Activate
Range("O25:Q25").Select
Application.CutCopyMode = False
Selection.Copy

Windows("RESUMO.xlsx").Activate
Worksheets(1).Cells(Rows.Count, 3).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Windows("ROMANEIO GERAL.xlsm").Activate
Range("W25:X25").Select
Application.CutCopyMode = False
Selection.Copy

Windows("RESUMO.xlsx").Activate
Worksheets(1).Cells(Rows.Count, 4).End(xlUp).Offset(1, 0).Select
'Worksheets(1).Range("D3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

'Worksheets(1).Range("E3").Select
Windows("ROMANEIO GERAL.xlsm").Activate
ActiveWindow.SmallScroll Down:=-15
Range("Q3:R3").Select
Application.CutCopyMode = False
Selection.Copy

Windows("RESUMO.xlsx").Activate
'Worksheets(1).Range("F3").Select
Worksheets(1).Cells(Rows.Count, 6).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Windows("ROMANEIO GERAL.xlsm").Activate
Range("W3:X3").Select
Application.CutCopyMode = False
Selection.Copy

Windows("RESUMO.xlsx").Activate
'Worksheets(1).Range("G3").Select
Worksheets(1).Cells(Rows.Count, 7).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

'Worksheets(1).Range("G3").Select
Windows("ROMANEIO GERAL.xlsm").Activate
Range("C3:E3").Select
Application.CutCopyMode = False
Selection.Copy

Windows("RESUMO.xlsx").Activate
'Worksheets(1).Range("H3").Select
Worksheets(1).Cells(Rows.Count, 8).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

'Worksheets(1).Range("M3").Select
Windows("ROMANEIO GERAL.xlsm").Activate
Range("O8").Select
Application.CutCopyMode = False
Selection.Copy

Windows("RESUMO.xlsx").Activate
Worksheets(1).Cells(Rows.Count, 13).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'Worksheets(1).Range("N3").Select

Windows("ROMANEIO GERAL.xlsm").Activate
Range("S8").Select
Application.CutCopyMode = False
Selection.Copy

Windows("RESUMO.xlsx").Activate
Worksheets(1).Cells(Rows.Count, 14).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Windows("ROMANEIO GERAL.xlsm").Activate

ActiveWindow.SmallScroll Down:=-3
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False

SALVAR = Range("AG3") & Range("AB3") & Range("E18") & Range("AB3") & Range("c5")

ChDir "L:\ARMAZEM RECEBIMENTO\ROMANEIOS FINALIZADOS"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"L:\ARMAZEM RECEBIMENTO\ROMANEIOS FINALIZADOS\" & SALVAR & ".pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
False

End Sub