VBA to highlight row based on duplicate cell from another sheet

Hello All!

So I have a sheet full of info(sheet1) and another sheet(sheet2) with a single column of numbers. Some of these numbers will match numbers in Column B on sheet 1. I'm trying to get it to compare each number in column B with Column A on sheet 2 and if it finds a match highlight the entire row...I feel like the syntax is right aside from where I'm trying to set the Interior colorindex.

It runs but but nothing happens. I was hoping for a little guidance.

Thanks!

Please Login or Register  to view this content.

Why not just use Conditional Formatting?

Try this.

Please Login or Register  to view this content.

Originally Posted by bakerman2

Try this.

Please Login or Register  to view this content.

Works Perfect! Thanks!

I'm not really sure what I did wrong...I guess I was looking at it from a standard visual basic view maybe? I ended up trying this before I saw your post...

Please Login or Register  to view this content.

Which didn't seem to work until I put a 1 in Sheet1 B2 and a 1 in Sheet2 A10....I ran that and it highlighted row 1....but nothing else...which told me I was close. However, when I debug stepped through the code it wasn't running like a normal nested loop. It should take Sheet1 B2 and then compare it to Each cell of Column A sheet 2 to check for a match until it hits the end of Column A, then it should move on to Sheet1 B3 and run through it again until it hits the end of Sheet1 ColumnB.....but when I step through it, it hits the nested loop, runs through the inner loop forever, then it moves to the outter loop and skips the inner loop until it ends.....which is not the way a nested loop works...so I'm not sure what the problem is, or if I did something wrong?

Either way thanks for the assist!

First thanks for the rep points.

You forgot to put the d back to it's starting value after completing the inner loop.

Please Login or Register  to view this content.

Because you didn't d keeps adding up instead of restarting from first row of column A in second sheet.