Return Arguments in cell formula as an array

[rougean]

I am having trouble finding a built in function the will allow me to collect a formula from a cell as an array of its arguments.

For example, is a cell has "=sum(A1,G4,L3)", i want an array of 3 with values A1, G4, L3.

My goal is to be able to change each argument as i please and return the new formula to the sheet.

Can anyone help with this?

 

[Andrew Poulsom]

Welcome to MrExcel.

I don't think there is such a built-in function. You would need VBA.

 

[rougean]

Hi! Thanks for your quick response.

You are saying that there are no vba functions to do this and i would have to build one myself, correct?

I'm not too sure from the way you phrased your repsonse. Maybe i didn't ask a good enough question.

I want to make the changes to the cell formula from vba. I am hoping that there is a vba function to do this.

I know the range object has a formula and formulaarray property but none of these will do the job.

Is there any vba function that i can use to accomplish this task?

 

[Arul.rajesh]

when writing the formula select the part "a1,g4,l3" and hit F9 key

 

[Andrew Poulsom]

To populate your array you would need to parse the formula. The Split function may help you do that.

 

[rougean]

Thank you. I'll give it a try.