This will work straight out of the box. All you need to do is place thiscode in the Worksheet module rather than a standard module. Thenwhenever you enter something in column B, the formula will turn up in C.