
A few years ago I posted my code for pasting values. It’s changed a bit since then. This morning, it looked like this: Sub CopyPasteValues() gclsAppEvents.AddLog “^+v”, “CopyPasteValues” If TypeName(Selection) = “Range” And Application.CutCopyMode = xlCopy Then Selection.PasteSpecial xlPasteValuesAndNumberFormats ElseIf Application.CutCopyMode […]