Comparing a range
Posted by M Walker on August 01, 2001 2:50 AM
I'm trying to check a range of values for values under 5. It is intended to keep track of stock so ideally if the level falls below 5 i would like the product description to be placed in a textbox on a userform. As it is i'm stuck. I don't understand VBA very well and could do with some serious help. I was given this code by Ivan
Set Stocklevels = Sheets("Totals").Range("b5:b337")
dim cell as range
dim comparerange as range
if cell < 5 then
But i don't understand what is actually being coded here so i can't fix the error message that appears when i run the macro.
ANy help would be appreciated.