Sorry Jacob but the picture's still unclear. Buddy, can you please simply
design a simple sum type of a function like:
=XSUM(Variable-1, Variable-2, ...., Variable-n)
With a ReDim statement used?
Thanx again,
Best Regards,
Faraz
"Jacob Skaria" wrote:
Use an array. In the below example variable arrTemp is redimensioned at
runtime to store values 1 to 1000..at position 1 to 1000...
http://msdn.microsoft.com/en-us/libr...s2(VS.71).aspx
Dim arrTemp As Variant
ReDim arrTemp(0)
For intCount = 1 To 1000
ReDim Preserve arrTemp(intCount)
arrTemp(intCount) = intCount
Next
--
Jacob
"Faraz A. Qureshi" wrote:
Sometimes you never know how many variables you would be needing to gather a
data.
For example, =SUM(Variable-1, Variable-2, ...., Variable-n)
How to declare the same in this regard? Any sample shall be appreciated.
--
Thanx in advance,
Best Regards,
Faraz