Tetranychus
New Member
- Joined
- Sep 21, 2014
- Messages
- 2
Hi all,
I just need help to get this right.
When i copy the macro copy all ( including formulas ) and what i want is just to copy the values.
Can any one help?
Sub Gerar()
Range("B28:AR29").Select
Selection.Copy
Sheets("testettt").Select
Range("B22:AR23").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Selection.EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Sheets("Dados Pessoais + Exper. Prof").Select
Range("A3").Select
End Sub
Tks and Best Regards
I just need help to get this right.
When i copy the macro copy all ( including formulas ) and what i want is just to copy the values.
Can any one help?
Sub Gerar()
Range("B28:AR29").Select
Selection.Copy
Sheets("testettt").Select
Range("B22:AR23").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Selection.EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Sheets("Dados Pessoais + Exper. Prof").Select
Range("A3").Select
End Sub
Tks and Best Regards