hi folks,

i am working on providing a VBA-based solution for this thread:

http://www.excelforum.com/showthread...=1#post2868374

i hit upon an issue which i am just not able to figure out how to solve.

the spreadsheet has a column of Data Validation cells (column F). if i were to type a value in every cell along a row and hit TAB (or the arrow keys), as soon as i reach column F, excel craps out. i have pop-up messages about "not enough resources" and i have no option but to End Task excel through Task Manager.

i do not have this experience if i hit enter after entering values, just when TAB or arrow keys.

please see if you can help. if you update the original thread, that would be great, too.