macro to sum all element in array and output it in one cell of excel.

suppose i have an array, like below:

Vehicle1 As String*2
MyArray(1)=mydata.Vehicle1

All I want to do is to sum each of the value in the array and output them in a cell of excel.
I do it like this

Sum = Sum.MyArray(1)
.Cells(lRow, 1) = Sum

but it is showing error. saying that object required.
What should I do?
Please help.