Hi
no problem with that :-) Glad it works now

--
Regards
Frank Kabel
Frankfurt, Germany

Robert Couchman wrote:
BIG APPOLOGY!!!

yes i had tried the code, but it didnt work, logically i
have found out why it will not do the check!

the update for the cell for that is being used as a cell
to check to was not a value! i acidently inputed the data
as text, therefore no mathmatical lookup would work!!

my humble appology!!

just had to sift through lots of code to find it!!
sorry!!

Thank you,

Robert Couchman

P.S. original code worked perfect after, sorry i didnt use
your code but i do not need to select the information as i
have 600 records!!