IF Cell.Value partly equals

Hi all, hope your doing well

I need help with 'looking' at part of the value of a cell.

I am looking down a column for a specific term - 'Ford' - however these values cannot be found as my cells have extra data in them such as 'Ford1965' or 'FordRacing' etc etc

How can i get VBA to use a function such as Left(A1,4) to check if the first # of characters match my search term?

Regards

Maybe InStr?
something like

Please Login or Register  to view this content.

You can use this code

Please Login or Register  to view this content.

or this

Please Login or Register  to view this content.

Thank you Nilem

how do i modify this such that it works in the example below..

Please Login or Register  to view this content.

Thank you kvsrinivasamurthy i got it working using your first example.
But now another Issue has arrised..

Please Login or Register  to view this content.

whilst I am in a With Range is it possible to move .cut a row outside of this range..
i.e. once the condition for the If statment above are met then how can i cut not only the Range("A" & Rw) but also 1 row above and 1 row below Rw ?

Solved, Called to another sub routine. thanks guys!

Please Login or Register  to view this content.