Clara,

try something like this:

Sub Test

With Workbooks("Book1").Sheets("Sheet1")
.Range("A1:A3").Copy
Destination:=Workbooks("Book2").Sheets("Sheet1").R ange("A1")
End With

End Sub



--
Hope that helps.

Vergel Adriano


"clara" wrote:

Hi all,

I have to copy a part of a sheet and paste into another workbook's sheet,
how can I paste value and format?

Clara


--
thank you so much for your help