If one wishes to paste both values and formulas, how is this done?
Selection.PasteSpecial _
Paste:=xlPasteValues, _
Paste:=xlPasteFormulas, _
... ?
If one wishes to paste both values and formulas, how is this done?
Selection.PasteSpecial _
Paste:=xlPasteValues, _
Paste:=xlPasteFormulas, _
... ?
i wonder what you are expecting as a result as they are mutually exclusive?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Range("MyRangeA").Copy With Range("MyRangeB") .PasteSpecial xlPasteValues .PasteSpecial xlPasteFormulas End With
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Why not simply this?
Which will take care both formulas and valuesSelection.PasteSpecial Paste:=xlPasteFormulas
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Woof. So "formulas" includes all the "static" values?... Once again embarrassed, but once again learned something new. Thank-you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks