What code may be applied with respect to only ONE sheet, upon which if any
data is pasted (either by Ctrl+V or Enter) only the values are pasted so as
to preserve the format and application of Conditional Formatting?

Signature
Best Regards,
FARAZ A. QURESHI
Jim Rech - 26 Mar 2008 13:26 GMT
I don't know what you mean by 'code'. There is no cell format that
restricts a cell to being the recipient of pasted values only.
For a macro you might see if this holds water. Copy it into the sheet's
module (right click sheet tab and pick View Code):
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Temp As Variant
Temp = Target.Formula
With Application
.EnableEvents = False
.Undo
Target.Formula = Temp
.EnableEvents = True
End With
End Sub

Signature
Jim
| What code may be applied with respect to only ONE sheet, upon which if any
| data is pasted (either by Ctrl+V or Enter) only the values are pasted so as
| to preserve the format and application of Conditional Formatting?