Hi Guru's

Ok so i have found a vba thats perfect for my needs and works ...Sort of....

If a cell value is less than 3 it does send an email however my problem is i need it to send a email when M6 who's formula is ='Parts List'!L5 shows a value of less than 3 which for some reason this VBA refuses to do? infact it will only send an email if a standard cell shows a figure and not the result of a formula so what am i doing wrong?

I also cannot just reference cell L5 on the parts list tab either as that is a formula too =Stock!K6-'Parts List'!K5 ..... the formulas work fine and simply display the value in numeric form but as mentioned the below VBA just wont work when referencing a formula result?

PLEASE HELP!!!

HTML Code: