Mackeral
Board Regular
- Joined
- Mar 7, 2015
- Messages
- 237
- Office Version
- 365
- Platform
- Windows
VBA Code:
With SHEET.Range("A3:A321")
Hold = .Find(What:="Albany Tire", LookIn:=xlValues)
End With
If Hold <> "" Then
Answer_Row = Hold.Row ' Error on this line
Answer_Col = Hold.Column' Error on this line
End If
This code use to work but doesn't now.
Cell("A23") contains "Albany Tire",
Both the "Answer" lines give errors now.
What's wrong? Many thanks.