I am posting this again, just incase people missed it the first time.

Hi all of you,

I hope somebody can help me on this one. I have data validation in force on some worksheet cells and limit the value range of the cell from 2-4. The problem is whenever I enter an invalid value say 7, excel gives me a log scale error followed by "Excel cannot complete this task with the resources available". Presumably, Excel is calculating inspite of an invalid data entry(?). I have some code in worsheet_calculate event but is this a botheration?

I use Excel 2003 and my computer memory is sufficiently high at 512MB.

Any help is highly appreciated.