Bom dia!!
Elimine a linha ActiveSheet.Paste, faça os teste!
Do While Worksheets("RESUMO").Cells(Coluna, 1) <> ""
Coluna = Coluna + 1
Loop
ActiveSheet.Range(Worksheets("RESUMO").Cells(15, 4), Worksheets("RESUMO").Cells(Linha - 1, Coluna)).Select
Selection.Copy
Range("B14").Select
Sheets("Produtividade").Select
Desprot
Range("M1").Select
Sheets("Produtividade").Range("P1:P100").Select
Selection.Copy
Range("L2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Existem mil maneiras de preparar Neston. Invente a sua!
http://www.youtube.com/ExpressoExcel
Postado : 02/03/2012 6:43 am