How to return the sum of variables which change in a loop

Hi there !
Just wanted to ask you a quick question. I've a VBA code which changes accordingt an input parameter i which changes every time depending where it is in the loop.
say for example the return value is return(j) which changes for each value of j.

I want a code which will return the value of the sum of all the return(j) for j=1 to n
I have tried using
[VBA]
Sub g()
for j =1 to n
Return (j) = .......someinputformla which is dependent on (j)
g=worksheetfunction.sum(return(j))
Cells(1,1) = g
Next j
End sub
[/VBA]
But it does not work....basically,i just wanna know how to sum the return (j)
Thanks for yourtime
Regards
Haarish

Haarish

It isn't clear, to me anyway, what you actually want to sum.

Hi Haarish,
Since this appears to be an excel question(reference to worksheet) I am going to move this thread to the Excel help forum so that others looking to help with excel questions can find it.....

Hi Haarish,
Welcome to VBAX

Try something like

[VBA]
Sub AddJ()
Dim g As Double, j As Long
g = 0
For j = 1 To [A1]
g = g + DoStuff(j)
Next j
Cells(2, 1) = g
End Sub

Function DoStuff(j As Long) as Double
Select Case j
Case Is < 3
DoStuff = j ^ 3
Case Is < 10
DoStuff = j ^ 4
Case Is < 20
DoStuff = j ^ 2
End Select
End Function
[/VBA]

MD,

I like the function name! I use the stuff suffix frequently...especially with my ToggleStuff routine I usually use to handle events and screenupdating.

Hopefully the OP comes back with more questions or to advise if the suggestion worked or could be applied to his need...