Your problem has nothing to do with Excel or components, it's just the way you misuse vectors.
There is a bit of an oddity about the Excel component. You carefully pass a couple of values as parameters, but you also have a number of hard coded constants. I suspect that changing the input parameters will just result in inconsistent results.
Your real problem is a failure to keep track of what is a scalar (or an element of a vector) and what is a vector. In your definitions of AreqgLRFD and Tmax_Test the argument di (with the i a confusing literal subscript) is a scalar (passed that way because of the vectorization of the calls to these function), but Zvi is a vector (not an element of a vector). The result of the multiplication is therefor a vector. So when you invoke these functions for each element of the vector di (a worksheet vector valued variable, distinct from the scalar argument di) you get a vector of vector results.
__________________
� � � � Tom Gutman