Macro Help

Catalin.B · #5 06-08-2013, 01:36 AM

tmill29, please upload a sample file with your data structure, in those 2 sheets, it will increase your chances to receive an answer...
The following code might do what you need, but is not tested on your data:

Code:

Sub HighlightRowsWithMyNumbers()
Dim cell As Object
Dim i As Integer

Application.ScreenUpdating = False
    On Error Resume Next
  
For Each cell In Sheets("sheet1").UsedRange
    i = Application.Match(cell, Sheets("sheet2").Range("a2:a226"), 0)
        If Not Err.Number <> 0 Then
             Sheets("Sheet1").Rows(cell.Row).EntireRow.Interior.Color = vbYellow
        End If
    Err.Clear
Next cell
    On Error GoTo 0
Application.ScreenUpdating = True
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I assign a macro to a button when the macro is in my personal workbook?	foolios	Excel Programming	2	07-27-2011 02:41 PM