Is there an Excel 2010 equivalent for FORMULATEXT?

[mRoy62]

The formula I have in cell A1 is ='New Product Business'!A11.
I would like other cells in the current worksheet to be relative to this formula.
I came across FORMULATEXT and it seems that by combining this with OFFSET I could achieve what I need to do.
However, I have Excel 2010 and FORMULATEXT is not available in that version.
Any ideas?

 

[sheetspread]

Here's the UDF, it's easy (from Bill Jelen's podcast)

Function FT(mycell As Range)
FT = mycell.Formula
End Function

If I knew what you wanted to do exactly I could suggest a native formula alternative.