how to setup GETFORMULA() in EXCEL 2003?

[Guest]

Can someone please explain how to setup GETFORMULA() in EXCEL 2003? thanks...

 

[Guest]

thanks again....is this function will not cause any trouble say like a
volatile one...
--
"Bright minds are blessed to those who share them.."-rsb.

Glad it works, thank you for your feedback.
David McRitchie gives the following examples:

=GetFormula(A1) -- Display the formula used in cell
A1
=GetFormula(sheet150!A1) -- get the formula used on another
worksheet
=GetFormula([WBName.xls]WSName!A1) -- from another workbook with
caution

Anthony

would this module good to get formula from another worksheet or even from
another workbook?

 

[Guest]

Not sure if this is the meaning of volatile you are referring to ?
The default is that a user defined function (UDF) is volatile -
"The function will be recalculated whenever calculation occurs in any cells
on the worksheet on which this function appears."
A UDF can be set to be non-volatile instead:

Function GetFormula(Cell as Range) as String
Application.Volatile(False)
etc.

Hth
Anthony
ps (going offline now, back tomorrow)

thanks again....is this function will not cause any trouble say like a
volatile one...
--
"Bright minds are blessed to those who share them.."-rsb.

Glad it works, thank you for your feedback.
David McRitchie gives the following examples:

=GetFormula(A1) -- Display the formula used in cell
A1
=GetFormula(sheet150!A1) -- get the formula used on another
worksheet
=GetFormula([WBName.xls]WSName!A1) -- from another workbook with
caution

Anthony

would this module good to get formula from another worksheet or even from
another workbook?
--
"Bright minds are blessed to those who share them.."-rsb.


:

Hi Romelsb,

Would this link be helpful ?
http://www.mvps.org/dmcritchie/excel/formula.htm
giving the code for GetFormula as a User Defined Function.
This may be entered via Tools, Macro, Visual Basic Editor, Insert Module.

Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function


Regards
Anthony

:

Can someone please explain how to setup GETFORMULA() in EXCEL 2003? thanks...

 

[Greg Glynn]

No idea.

I'm not sure that it's a standard function. What's it supposed to do?


Greg

 

[Greg Glynn]

Maybe you're referring to this?

http://www.andrewsexceltips.com/menu_vba_get_formula.htm

 

[David McRitchie]

I would not include VOLATILE in the function, you can use F9
to recalculate the sheet. After all it is a debugging/documentation tool.
If you change the referenced cell
then the function will recalculate. as long as Calculation is turned on.

Documentation is at http://www.mvps.org/dmcritchie/excel/formula.htm
sorry if that was already mentioned, I lost my copies of these newsgroups last
night and decided to just add new messages without re-obtaining the old
messages.

thanks again....is this function will not cause any trouble say like a
volatile one...
--
"Bright minds are blessed to those who share them.."-rsb.

Glad it works, thank you for your feedback.
David McRitchie gives the following examples:

=GetFormula(A1) -- Display the formula used in cell
A1
=GetFormula(sheet150!A1) -- get the formula used on another
worksheet
=GetFormula([WBName.xls]WSName!A1) -- from another workbook with
caution

Anthony

would this module good to get formula from another worksheet or even from
another workbook?
--
"Bright minds are blessed to those who share them.."-rsb.


:

Hi Romelsb,

Would this link be helpful ?
http://www.mvps.org/dmcritchie/excel/formula.htm
giving the code for GetFormula as a User Defined Function.
This may be entered via Tools, Macro, Visual Basic Editor, Insert Module.

Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function


Regards
Anthony

:

Can someone please explain how to setup GETFORMULA() in EXCEL 2003? thanks...