Re: $$Excel-Macros$$ Tricky tricks - 1

2013-08-23 Thread De Premor
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?

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-30 Thread ravinder negi
__ From: xlstime To: excel-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 wrote: using udf >On Cell A3, type=Ev

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-30 Thread xlstime
Good one ..very simple code . Enjoy Team XLS On Tue, Jul 30, 2013 at 5:43 PM, Prafull Jadhav wrote: > 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

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-30 Thread Prafull Jadhav
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 wrote: > if we have more then thousands of records than? > > . > > Enjoy > Team XLS > > > >

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-30 Thread xlstime
if we have more then thousands of records than? . Enjoy Team XLS On Mon, Jul 29, 2013 at 9:41 PM, Secret Shot 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 wrote: > >> create defined name i

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-29 Thread Secret Shot
Put "=" sign in cell A2 itself at the bagining of the text... :P On Sun, Jul 28, 2013 at 1:46 PM, De Premor 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, xlstim

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-28 Thread De Premor
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

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-28 Thread xlstime
and what about formula . Enjoy Team XLS On Sun, Jul 28, 2013 at 11:10 AM, De Premor 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 Function**

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-27 Thread De Premor
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 su

$$Excel-Macros$$ Tricky tricks - 1

2013-07-27 Thread xlstime
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 Faceb