Hi
I am using the below code to Find two strings in column A and select the cells between them.
I would like to loop through the entire range as the two strings appear more than once.
Sub SelectBetween()
On Error GoTo errhandler
Dim fOne As String
Dim fTwo As String
fOne = "First"
fTwo = "Second"
Range(Range("A:A").Find(fOne).Offset(0), Range("A:A").Find(fTwo, Range("A:A").Find(fOne)).Offset(-2)).Select
Dim myrng As Range
Set myrng = Selection
With myrng.Font
.Bold = True
End With
Exit Sub
errhandler:
MsgBox "No Cells containing specified text found"
End Sub
Thanks for any assistance
Jeff
Bookmarks