Simple Paste Question

  • Thread starter Thread starter shawn
  • Start date Start date
S

shawn

How can I get the code below to paste formulas and formats
as well as values?


..PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
 
..PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
 
Shawn,

Change your Paste:=xlValues to Paste:=xlPasteAll

Look in the Microsoft Excel Visual Basic help for the
pastespecial method for all of the valid options for
pastespecial.

Sincerely,

Kris
 
You must log in or register to reply here.

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

Help with condensing a lot of copying/pasting... 4
Run-time error 1004 paste method of worksheet class failed 3
Conditional Formatting 1
Type mismatch error 1
Run-time error '1004': Methor 'Range' of object '_Global' failed 3
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, 2
copy paste problem 4
Run-time error '1004': 1

Back
Top