I get an error still. "out of range"
![]()
Sub DixieDiver() Dim x As String Dim i As Long Dim y As Range Workbooks("Missing PI Tags 20141021b.xlsx").Sheets("Jacobs").Activate For i = 1 To 500 x = Range("A" & i).Value Set y = Workbooks("DB (Old App).xlsx").Sheets("DB (Old App)").Columns(1).Find(x, LookIn:=xlValues, lookat:=xlWhole) If Not y Is Nothing Then Workbooks("DB (Old App).xlsx").Sheets("DB (Old App)").Cells(y.Row, y.Column).Interior.ColorIndex = 6 End If Set y = Nothing Next i End Sub
Bookmarks