I have this code to select range of cells that equal to China in a master sheet. However i know this code can be simplified. Can you guys help me? Basically i want to select a column A cells of a country in a mastersheet. Can't figure out how to improve this.
Sub macro65()
Dim first As Integer
Dim second As Integer
For Each Cell In Range("A:A")
If Cell.Value = "CHINA" Then
first = Cell.Row
Exit For
End If
Next Cell
second = first
For Each Cell In Range("A:A")
If Cell.Value = "CHINA" Then
second = second + 1
End If
Next Cell
Range(Cells(first, 1), Cells(second - 1, 1)).Select
End Sub
Thank You
Bookmarks