I am using custom copy paste function in my Excel VBA. I trap the key
strokes for paste key and use Selection.PasteSpecial
Paste:=xlPasteValues, Operation:=xlPasteSpecialOperationNone,
SkipBlanks:=False, Transpose:=False function for copy paste. I have
some formula cells on my excel which are protected. If I try to paste
on these formula cells individually (single cell) it does not paste
anything since they are protected.But when I try to paste onto
multiple cells it over writes the values on to my formula cells there
by losing the formulas.