Pass variable number of arguments to worksheetfunction

[amphinomos]

Hi,

I have an array with strings "M","P","R" (size of the array varies from 2 to n) which refer to columns. I'm trying to write a procedure/function that will take the array and write the function "=SUM(M3,P3,R3)" to Q3 in this case (formula would need to be visible). Would there be any way to loop inside worksheetfunction.sum(arg1,arg2,arg3 etc.) or with range("Q3").Formula = "=arg1+arg2+arg3 etc."?

Thanks,
amphi

[StephenR]

Do you mean you want the actual formula to appear as you describe or you just want the sum evaluated and put in Q3? If the former, why do you need it?

[amphinomos]

I'm looking to have the actual formula in the worksheet. I'm distributing the code and need to keep the formula for the other users.

[StephenR]

But why is it easier to to use your approach than to just write the formula in the cell?

Anyway it can be done.

[amphinomos]

Ok thanks good to know. So using something like a lbound/ubound loop to store in a string and the range.value property ?

[StephenR]

I can post some code later if nobody else steps in.

[StephenR]

So here is one way. You have to call the first procedure from another. Another parameter could be added to specify the location of the formula.

Please Login or Register  to view this content.

[amphinomos]

Thanks so much ! With your solution, I understand why the request is a bit "clunky".

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.