Try this:
![]()
Sub Scabtree(): Dim r As Long r = 99: Do If LCase(Left(Cells(r, 1), 3)) = "pri" Then _ Cells(r, 1).Select: Exit Sub r = r - 1: Loop Until r = 0 End Sub
Try this:
![]()
Sub Scabtree(): Dim r As Long r = 99: Do If LCase(Left(Cells(r, 1), 3)) = "pri" Then _ Cells(r, 1).Select: Exit Sub r = r - 1: Loop Until r = 0 End Sub
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks. I just gave A100 as an example. The active cell could be any cell in column A. Sorry for the trouble/lack of clarity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks