Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub juntarfim()
- '
- Range("A1").Select
- Sheets("PLANILHA1").Select
- Range("A5:E500").Select
- Application.CutCopyMode = False
- Selection.Copy
- Sheets("CONSOLIDADOJUNTOS").Select
- ActiveSheet.Paste
- '
- Range("A501").Select
- Sheets("PLANILHA2").Select
- Range("A6:E500").Select
- Application.CutCopyMode = False
- Selection.Copy
- Sheets("CONSOLIDADOJUNTOS").Select
- ActiveSheet.Paste
- '
- End sub
- Sub juntarfim()
- Application.ScreenUpdating = False 'desativa atualização de tela.
- Range("A1").Select
- Sheets("PLANILHA1").Select
- Range("A5:E500").Select
- Application.CutCopyMode = False
- Selection.Copy
- Sheets("CONSOLIDADOJUNTOS").Select
- ActiveSheet.Paste
- '
- Range("A501").Select
- Sheets("PLANILHA2").Select
- Range("A6:E500").Select
- Application.CutCopyMode = False
- Selection.Copy
- Sheets("CONSOLIDADOJUNTOS").Select
- ActiveSheet.Paste
- '
- End sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement