Hi,

Could someone help me with this please. I have a need to populate the range
of a Sum formula with a text string that I have dynamically created as the
result of several other variables in my workbook. The text string reads
"SUM(B5:B14)" but every time I try to use it as an argument in a larger
formula in another cell, it doesn't work.

Is there a way to pass text into a formula as an argument?

Thanks