Select first and last occurence of a word

[YasserKhalil]

Hello everybody
I have these values in range("A1:A10")
A
A
A
A
B
B
B
A
A
A
I used the following line to select the first occurence of "A"

Please Login or Register  to view this content.

And used this line to select the last occurence of "A"

Please Login or Register  to view this content.

As for the line of the first occurence the code selects A2 not A1

How can make the code select A1 instead of A2?

[Kaper]

make sure you give a good starting point for search. by default it is a first cell of searched range, so if the direction is xlprevious it works fine, but if it is xlnext (default one) it starts to search under the first cell. In typical situations it is fine, because there is often a header in a first cell.
But in situation described :
A
A
A...

use last cell of searched range as starting point.

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot for this quick help
You are very helful