jim may
Well-known Member
- Joined
- Jul 4, 2004
- Messages
- 7,486
I'm getting R/T Error 1004 on RED Line below;
My Range(C2:C5) are 4 strings (AA, BB, CC, DD)
My target cell - while a formula cell - returns a string - such as BB
Ant assistance appreciated.. Jim
My Range(C2:C5) are 4 strings (AA, BB, CC, DD)
My target cell - while a formula cell - returns a string - such as BB
Ant assistance appreciated.. Jim
Rich (BB code):
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address <> "$E$1" Then Exit Sub
Dim r As Long, v As String
Cancel = True
Set Rng = Range("C2:C5")
Worksheets("Sheet2").Activate
r = Application.WorksheetFunction.Match(Target.Value, Rng, 0)
Cells(r, 3).Select
End Sub