Thanks for the reply but no. It still fails on row J. After multiplying J16 into E and F16 then letting XL compare using IF in G16, XL indicates equal yet the VB still shows unequal.
I have uploaded the problem VBA at
https://docs.google.com/leaf?id=0ByeU-4Navqg8MDBkNDQxNTQtMTJjZi00NTVmLTliZjctODIwZDIxOGU5NjYy&hl=en_US&authkey=CJD54LQB
I want to validate a numeric field has two or less decimals, i.e 123.456 is bad.
The field is pasted from another XLS where it was...