Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,592
- Office Version
- 365
- 2016
- Platform
- Windows
I have this code where the line in red is giving me a type mismatch error.
tmrow = 34, and tmcol = 4
The value in cell(34,4) is text "Baltimore Nuggets"
Is anyone able to help me understand what might be causing this error?
Rich (BB code):
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not mbevents Then Exit Sub
tmrow = Target.Row 'trow = Target.Row
tmcol = Target.Column 'tcol = Target.Column
If tmcol < 13 Or tmcol > 16 Then
If Target.Value = "" Then Exit Sub
End If
mbevents = False
...
End Sub
tmrow = 34, and tmcol = 4
The value in cell(34,4) is text "Baltimore Nuggets"
Is anyone able to help me understand what might be causing this error?