how to paste with value and format
 

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

how to paste with value and format
 

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

how to paste with value and format
 

With both workbokks open Right-click the sheet tab you want to copy
from and go to Move or Copy. select the correct work book in the To
book: drop field. Make sure the "create copy" check box is ticked.
Once copied you can delete the stuff yo don't need...

On Aug 2, 2:34 pm, 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