VBA Finding the last matching cell

[Chuyx]

How can i find and select the last cell that matches my value value in column A. I have this but always goes to the first value of the column and i need it to go to the last one

Columns(“A”)Find(myValue).Select

 

[Fluff]

Hi & welcome to MrExcel.
How about

Range("A:A").Find(myValue, , , xlWhole, xlByRows, xlPrevious, False, , False).Select

 

[Chuyx]

Hi & welcome to MrExcel.
How about

Range("A:A").Find(myValue, , , xlWhole, xlByRows, xlPrevious, False, , False).Select

thank you very much for the response, i got an error
Wrong number of arguments or invalid property assignment.

 

[Fluff]

Did you copy/paste the code, or type it out?

 

[Chuyx]

Did you copy/paste the code, or type it out?

I typed it out

 

[Chuyx]

I typed it out

Wait it’s working, i typed it out wrong. Thank you very much, i appreciate it

 

[Chuyx]

Wait it’s working, i typed it out wrong. Thank you very much, i appreciate it

I typed it out

Could you explain the code, please?

 

[Fluff]

You're welcome & thanks for the feedback.
You can find out about the various arguments for range.find here Range.Find method (Excel)