Type mismatch error'13'
If there's an error in the changed range, then target.value will cause an error.
If you change more than one cell, then target.value can't be compared to a
single number.
Curt wrote:
anyone see why this creats this error
Thanking you in advance
If target.Column = 10 And target.Value 10 Then
Private Sub Workbook_SheetChange(ByVal sh As Object, ByVal target As Range)
Dim wksSummary As Worksheet
Dim rngPaste As Range
Select Case sh.Name
Case "Data", "Motorcycle", "Indian", "Native"
'1=data 6=Motorcycle 7=Indian 8=Native nbrs
If target.Column = 10 And target.Value 10 Then
Call CopyStuff(sh, target)
End If
End Select
End Sub
--
Dave Peterson
|