Re: Help with function/cond. formatting

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Gord Dibben <gorddibbATshawDOTca>
Date: Wed, 21 Dec 2005 13:42:38 -0800

Bob

The function I posted works for me. Why the Evaluate added in your version?

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

D3 contains (6+3+3)/4

=EvalCell(D3) returns 3

Gord

On Wed, 21 Dec 2005 19:10:06 -0000, "Bob Phillips"
<bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote:

>Use
>
>Function EvalCell(RefCell As Range)
>EvalCell = Evaluate(RefCell.Value)
>End Function
.

Follow-Ups:
- Re: Help with function/cond. formatting
  - From: Bob Phillips

References:
- Help with function/cond. formatting
  - From: Roz
- Re: Help with function/cond. formatting
  - From: Roz
- Re: Help with function/cond. formatting
  - From: Bob Phillips
- Re: Help with function/cond. formatting
  - From: Roz
- Re: Help with function/cond. formatting
  - From: Bob Phillips
- Re: Help with function/cond. formatting
  - From: Roz
- Re: Help with function/cond. formatting
  - From: Bob Phillips

Prev by Date: Re: How do I sort or count cells by fill color?
Next by Date: Re: Attaching a 2 item list to a cell / drop-down?
Previous by thread: Re: Help with function/cond. formatting
Next by thread: Re: Help with function/cond. formatting
Index(es):
- Date
- Thread

Relevant Pages

Re: how do you use formulas in a drop down box
... With the help of a UDF......which you can copy to a General Module in your ... workbook. ... Function EvalCell(RefCell As String) ... EvalCell = Evaluate ...
(microsoft.public.excel.worksheet.functions)
Re: how does one convert text to a formula "average(A:A)" to =average(
... You can employ a UDF. ... Function EvalCell(RefCell As String) ... EvalCell = Evaluate ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
Re: Add #s in one cell...Solution in other cell
... Function EvalCell(RefCell As String) ... EvalCell = Evaluate ... I think you are setting yourself up for future problems using this method. ... >I'm trying to get the sum of two numbers in one cell to ...
(microsoft.public.excel.worksheet.functions)
Re: Help with function/cond. formatting
... EvalCell = Evaluate ... (remove nothere from email address if mailing direct) ... > Function EvalCell(RefCell As String) ...
(microsoft.public.excel.misc)