Calling Function on IF = Yes

I want to circle some cells on a table on Sheet2 (workbook attached) if they correspond to cell values on a seperate row in Sheet1.

I tried the code by defining a single cell and therefore know the code for the circling bit works, I just don't seem to be able to get it to scan the table and conduct the operation as required. The code below is what I'm back to after several hours of frustration....

Surely it's doable?

Please Login or Register  to view this content.

Can anybody help please ...

Try this.

Please Login or Register  to view this content.

Thanks Martin

It works fabulously. Just looking at what you did I can read it back perfectly but couldn't have thought of it yet (if that makes sense!). Using the Application.countif does that mean you can essentially quote an excel formula? I mean could I do the same for a VLOOKUP or AND statement?

i.e.

Please Login or Register  to view this content.

Apologies if that sounds dumb but I'm still at the early stages of learning VBA.

p.s. Are you the QA Trg Martin?

Yes is does - have a look also at WorksheetFunction in Excel help.

Re QA TRG - I assume not as I don't know what these are