"Sub PasteValues()
Selection.PasteSpecial Paste:=xlValues
End Sub"
Hello could you give me the meaning of this "Selection.PasteSpecial Paste:=xlValues" ?
what does this line do?
"Sub PasteValues()
Selection.PasteSpecial Paste:=xlValues
End Sub"
Hello could you give me the meaning of this "Selection.PasteSpecial Paste:=xlValues" ?
what does this line do?
If you have selected a range containing formulas, the "PasteSpecial Paste:=xlValues" will paste, well, the values of the formulas, not the formulas.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks