Use FIND to find a Row Number

[Mackeral]

   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.

 

[Cubist]

Try

If Not Hold Is Nothing Then
    Answer_Row = Hold.Row
    Answer_Col = Hold.Column
End If

 

[MARK858]

Can't see how that code would have worked without the word Set, without seeing the rest of the code try...

   With SHEET.Range("A3:A321")
         Set Hold = .Find(What:="Albany Tire", LookIn:=xlValues)
    End With

    If Not Hold Is Nothing Then
        Answer_Row = Hold.Row                    '      Error on this line
        Answer_Col = Hold.Column                 '   Error on this line
    End If

 

[Mackeral]

Thank you for your replies, but neither of them made my code work.

 

[MARK858]

Then you need to post your full code and an XL2BB of your data

Below is a link to a workbook with the code I previously posted (with a few variable declarations and message boxes) that works for me

mackerel.xlsm | Powered by Box

app.box.com

 

[MARK858]

Also is Albany Tire the only text in the cell?

 

[Mackeral]

Yes' "Albany Tires" is what is in cell("A23").

 

[MARK858]

If that is the only text in A23 then as I stated you need to post your full code and an XL2BB of your data

 

[MARK858]

Tires or Tire?

 

[Mackeral]

My correction: "Albany Tire" is what is in the lookup Sheet. So why isn't it found. It was before VBA got changed.
And I have downloaded "XL2BB"but can't read it> Errmsg says "
Mac