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.

 

[Mackeral]

It's Monday, and the original code works now.
Thanks for ruining our weekends by leaving up weekend code that doesn't work, so we can't work on weekends.

 

[Mackeral]

It's Monday, and the test code M/S over the weekend had disappeared and the regular code has been replaced
AND MY CODE WORKS TODAY.
I only wish I could have worked on it during the weekend. Not everybody only works 5 days a week.

 

[Mackeral]

My apology. I thought I'd closed this last week, but here it is now.

The reality is that when I tried my code on Sunday it didn't work. When I tried exactly the same code on Monday, it did work.
The problem as I see it now is that M/S is running a test version on the weekends which in which you will very likely find
something that doesn't. Last weekend, for instance, I was trying to use a system variable which was undefined on the weekend.
The ultimate solution is not to use 365 on weekends.

 

[Fluff]

In future please do not mark a post as the solution when it does not conatin one.
Thanks.

I use Excel all through the week & as far as I'm aware M/S do NOT run a "test" version at weekends.