a couple of laughzillas on a blue diamond background

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 […]