Macro not reading text ??? .

[Sunline]

Hello all ,

I have a macro which has always worked , it looks at past history .

Now to get it to work i have to filter each new name and copy it down .

I tested this on 5 names and the history data worked as normal .

The next cell which i didnt copy from above , this where macro didnt register the cell .

What should i be checking please .

Have all aligned left , same theme & size . ??????

Help needed please .
Thanks .

 

[mole999]

post your code between code tags here