I would start by substituting literal range references for the "range variables" you have......not exactly sure what you are doing there; maybe it works, and I am just ignorant of that syntax.
So, if "cdia" refers to "F5", use "F5" while troubleshooting your code.
I would also suspect that the ranges you are using as numbers may not be perceived as numbers. That should come back as Type Mismatch, shouldn't it?
The biggest issue I take with your code is anyone who might be at your side would first have to rewrite the code into less complex statements.
Are you sure that TextBox1 is being handled as a number?
Those range variables/literal strings, have you seen that construct used elsewhere? I haven't.
[ This Message was edited by: stevebausch on 2002-12-23 20:39 ]