Check range if multiple names exist then show msgbox

**c.pedersen** · 03-15-2012, 04:00 AM

Hi all.

I need a code where i input a range and it checks for multiple names and if all are listed in the range then shows a msgbox saying all names counted for if some are missing it should show which ones are missing.

I've looked around alot and found only using formula so you can check one and one name and show true false but instead of having 60 of codes of that it would be easier just to have a code?

Anyone willing to help me with this?

**dilipandey** · 03-15-2012, 05:21 AM

Ok..

So you'll have a set of names already with you and you want to check a range basis the set you have and then you need the counts against your name set ?
If so, please upload a sample file. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**c.pedersen** · 03-15-2012, 05:32 AM

I have a list of the names but these will be changed so maybe have the names listed in R3 and down and it will take all downwards untill hitting a blank cell? should be possible i guess like
fPATH = Cells(8 + y, 10).Value ?

**dilipandey** · 03-15-2012, 06:23 AM

Ok..

and where will be the Full Name list to which you want to match / count these name ?

Regards,
DILIPandey

<click on below 'star' if this helps>