How do I refer to a 'formula' instead of the result of tha..

MES · External Since: Mar 02, 2006 Posts: 4

I am trying to use a cell reference in one worksheet to a formula in another
worksheet, and want to use the formula itself instead of the result of that
formula, can anyone advise me how to do this?

Chris Marlow · External Since: Feb 23, 2006 Posts: 19

Hi,

I don't know if there is an existing Excel worksheet function to do this,
but the following VBA will;

Public Function ReturnFormula(Target As Range) As String

ReturnFormula = Target.Cells(1, 1).Formula

End Function

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master

"MES" wrote:

> I am trying to use a cell reference in one worksheet to a formula in another
> worksheet, and want to use the formula itself instead of the result of that
> formula, can anyone advise me how to do this?
>

MES · External Since: Mar 02, 2006 Posts: 4

"MES" wrote:

> I am trying to use a cell reference in one worksheet to a formula in another
> worksheet, and want to use the formula itself instead of the result of that
> formula, can anyone advise me how to do this?
>

fasta13 · External Since: Nov 06, 2009 Posts: 1

This just returns the formula as a text, is there a way that it will
calculate the function instead of showing the contents?

"Chris Marlow" wrote:

> Hi,
>
> I don't know if there is an existing Excel worksheet function to do this,
> but the following VBA will;
>
> Public Function ReturnFormula(Target As Range) As String
>
> ReturnFormula = Target.Cells(1, 1).Formula
>
> End Function
>
> Regards,
>
> Chris.
>
> --
> Chris Marlow
> MCSD.NET, Microsoft Office XP Master
>
>
> "MES" wrote:
>
> > I am trying to use a cell reference in one worksheet to a formula in another
> > worksheet, and want to use the formula itself instead of the result of that
> > formula, can anyone advise me how to do this?
> >

Gord Dibben · External Since: Feb 23, 2004 Posts: 9177

It is not clear to me what you want to do.

Can you post a formula and desribe what you want to do with it?

Maybe this UDF?

Function EvalCell(RefCell As String)
Application.Volatile
EvalCell = Evaluate(RefCell)
End Function

=evalcell(cellref)

Which does nothing more than return the value from the formula in cellref.

Just as easy to enter =cellref

Evalcell function is handy to return a value from a string such as

1+2+3

Gord Dibben MS Excel MVP

On Fri, 6 Nov 2009 16:35:01 -0800, fasta13
<fasta13.DeleteThis@discussions.microsoft.com> wrote:

>This just returns the formula as a text, is there a way that it will
>calculate the function instead of showing the contents?
>
>"Chris Marlow" wrote:
>
>> Hi,
>>
>> I don't know if there is an existing Excel worksheet function to do this,
>> but the following VBA will;
>>
>> Public Function ReturnFormula(Target As Range) As String
>>
>> ReturnFormula = Target.Cells(1, 1).Formula
>>
>> End Function
>>
>> Regards,
>>
>> Chris.
>>
>> --
>> Chris Marlow
>> MCSD.NET, Microsoft Office XP Master
>>
>>
>> "MES" wrote:
>>
>> > I am trying to use a cell reference in one worksheet to a formula in another
>> > worksheet, and want to use the formula itself instead of the result of that
>> > formula, can anyone advise me how to do this?
>> >