how to paste with value and format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Clara,

try something like this:

Sub Test

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

End Sub
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to make merged cells on a new sheet 2
how ot keep value and drop formula while copying 6
Keep destination formatting when pasting? 2
Formatting and copy or copy and formatting ?? 2
Count the columns from one sheet and paste it in another sheet 0
Paste special VB code. 1
PasteSpecial values pasting formula also?? 2
How to copy part of a sheet as a new sheet into another workbook? 1

Back
Top