Just figure it out after someone asking it again in another groups
Using Indirect in Defined Name to make it dynamic Row, but just work for
Column A :-D
=EVALUATE(INDIRECT(A ROW()))
On 30-07-2013 14:01, xlstime wrote:
if we have more then thousands of records than?
-macros@googlegroups.com
Sent: Sunday, July 28, 2013 1:29 PM
Subject: Re: $$Excel-Macros$$ Tricky tricks - 1
and what about formula
.
Enjoy
Team XLS
On Sun, Jul 28, 2013 at 11:10 AM, De Premor d...@premor.net wrote:
using udf
On Cell A3, type=Eval(A2
if we have more then thousands of records than?
.
Enjoy
Team XLS
On Mon, Jul 29, 2013 at 9:41 PM, Secret Shot secrets...@gmail.com wrote:
Put = sign in cell A2 itself at the bagining of the text... :P
On Sun, Jul 28, 2013 at 1:46 PM, De Premor d...@premor.net
Sir ,
Can we do this by using Macro
Sub prafull()
For Each x In Range(B2:B10)
x.Value = = x.Value
Next
End Sub
Regards,
Prafull
On Tue, Jul 30, 2013 at 12:31 PM, xlstime xlst...@gmail.com wrote:
if we have more then thousands of records than?
.
Enjoy
Team XLS
Good one ..very simple code
.
Enjoy
Team XLS
On Tue, Jul 30, 2013 at 5:43 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Sir ,
Can we do this by using Macro
Sub prafull()
For Each x In Range(B2:B10)
x.Value = = x.Value
Next
End Sub
Regards,
Prafull
Put = sign in cell A2 itself at the bagining of the text... :P
On Sun, Jul 28, 2013 at 1:46 PM, De Premor d...@premor.net wrote:
create defined name in example : *Eval**A2* that referring to
=EVALUATE(A2)
Then in some cell in that sheet, just type *=EvalA2**
*
Pada 28/07/2013 14:59,
and what about formula
.
Enjoy
Team XLS
On Sun, Jul 28, 2013 at 11:10 AM, De Premor d...@premor.net wrote:
using udf
On Cell A3, type* =Eval(A2)*
then, on VBE, add module and paste this code
*Function eval(str As String)**
**eval = Evaluate(str)**
**End
create defined name inexample : *Eval**A2* that referring to =EVALUATE(A2)
Then in some cell in that sheet, just type *=EvalA2**
*
Pada 28/07/2013 14:59, xlstime menulis:
and what about formula
.
Enjoy
Team XLS
On Sun, Jul 28, 2013 at 11:10 AM, De Premor
Hi All,
How to Evaluate cell value.
let assume that, in cell A2 - '1+2+3+4'
now how to sum or calculate cell value
hint: evaluate
.
Enjoy
Team XLS
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
using udf
On Cell A3, type*=Eval(A2)*
then, on VBE, add module and paste this code
*Function eval(str As String)**
**eval = Evaluate(str)**
**End Function**
*:-X
On 28/07/2013 12:09, xlstime wrote:
Hi All,
How to Evaluate cell value.
let assume that, in cell A2 - '1+2+3+4'
now how to
10 matches
Mail list logo