This may be a problem that is beyond a formula.... Please see link to current thread.

http://www.excelforum.com/excel-form...formation.html