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.
Please Login or Register to view this content.
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 valuesPlease Login or Register to view this content.
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