Results 1 to 2 of 2
2008-02-19, 19:45 #1
- Join Date
- Jan 2001
- Redcliff, Alberta, Canada
- Thanked 5 Times in 5 Posts
Function to extract Formula (2003/SP2)
I'm having a drop out or perhaps it is because I'm also trying to play with 2007 simultaneously. I'm trying to remember a function that will allow me to reference the formula in another cell, not the result.
My goal: I have multiple references to external workbooks in this file. I want a double check that cells in each row are referring to the same external file.
TIA[b]Catharine Richardson (WebGenii)
WebGenii Home Page
Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile
2008-02-19, 20:19 #2
- Join Date
- Aug 2004
- Connecticut, USA
- Thanked 0 Times in 0 Posts
Re: Function to extract Formula (2003/SP2)
What about pressing ctrl+` (the key above the <!t>[tab]<!/t> key) to display the formulas and then pressing it again to hide them again.
I don't think there is a built in function that will display the formula otherwise. You could create your own. I use:
<pre>Function ShowMe(Ref As Range) As String
ShowMe = Ref.Formula