If I have the following formula

=SUBTOTAL(3,D2:D10) which equals 9

I would like to extract the range D2:D10 out and use it in another formula. However all that I'm geting is the result of the formula (9) not the "text" of the formula.

Here 's a way if you're not opposed to a UDF approach. To Start, here's a little UDF that will translate a formula to a string of text:

Code:

```
Function FormulaText(x As Range) As String
FormulaText = x.Formula
End Function
```

In another cell, type the formula:

=FormulaText(D12) (assuming your subtotal formula is in D12)

This should kick out the string: "=SUBTOTAL(3,D2:D10)".

Now you're free to wrap a Find/Mid Combo to pull the D2:D10 part of the string. example:

=MID(formulatext(D12),FIND(",",formulatext(D12))+1,6) will pull "D2:D10" as a string. You could then use INDIRECT with that string in other formulas.

Hope that helps somewhat