Hola
Juan Carlos
esta perfecta tu ayuda, intente con los comandos que me enviaste agregar de bajo delo queme enviaste los siguiente e igualmente no se como poner ese rango variable
Range("L10").Select
ActiveCell.FormulaR1C1 = "=ROUND(RC[-2],0)"
Range("L10").Select
Selection.Copy
Range("J10").Select
Selection.End(xlDown).Select
Range("L34").Select
Range(Selection, Selection.End(xlUp)).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("L33").Select
Selection.End(xlUp).Select
Range("L10").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("J10").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("L10").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=ROUND(RC[9],0)"
Range("L10").Select
Selection.Copy
Range("L11").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("L10").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("U10").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("L10").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=ROUND(RC[10],0)"
Range("L10").Select
Selection.Copy
Range("L11").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("L10").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("V10").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("L10").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=ROUND(RC[11],0)"
Range("L10").Select
Selection.Copy
Range("L11").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("L10").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("W10").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("L10").Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.ClearContents
End Sub
espero me puedas ayudar
de antemano muchas gracias
Juan Carlos