Re: $$Excel-Macros$$ payback Period Formula / Macro

HI *Hope this Will makes some sens for you.* The word Dim is short for dimmension and is used to declare variables. Now, while Excel can still work quite happily if we omit the Dim (as long as we do not have Option Explicit), it comes at a price. Excel MUST store all undeclared variables as a

Re: $$Excel-Macros$$ Is it possible to hide the name manager menu?

Thanks Sam. I have figured out way to hide the names using a VBA macro. The table names (appearing in the name manager) only remains unhide, but that can be handled. Here is the routine that helped me. Sub HideAllNames() Dim nme As Name For Each nme In ThisWorkbook.Names If nme.Visible Then nme.

$$Excel-Macros$$ Re: Finding text within data

Share some more data with an example. Regards Prince On Tuesday, July 9, 2013 12:13:08 AM UTC+5:30, ha...@mst.edu wrote: > > Hi All, > Basically, I want to find a text from specific category and return the > text/number to a specific cell. > For example, > API NUMBER: (return the value here) >

Re: $$Excel-Macros$$ Macro to Replace Match Index Formula

Hi Anybody can help me on this.. On Sun, Jul 7, 2013 at 9:44 AM, Excel_Lover wrote: > Hi, > > I have a Form Control with Match Index formula, It's long formula and > works very slow but it gives required result. > > Hope somebody can help me with a macro to replace this formula. > > Ap

$$Excel-Macros$$ Finding text within data

Hi All, Basically, I want to find a text from specific category and return the text/number to a specific cell. For example, API NUMBER: (return the value here) Find API number from the following text(be aware:API # is always 10 numbers separated by dashes e.g. nn-nnn-n) -

Re: $$Excel-Macros$$ Macro to remove a timestamp in a date

Thank you Enrique. How do I set this up in a code to be able to use in a command button? I am familiar with codes in visual basic but not an expert by any means in writing them. On Wednesday, July 3, 2013 7:15:00 PM UTC-5, Enrique Martin wrote: > you can use = text(cell,"dd mmm "),

Re: $$Excel-Macros$$ Sumproduct help

Hi All, Thanks its working fine. Regards, Chandra On Tue, Jul 2, 2013 at 8:51 PM, De Premor wrote: > Try using SUM with CSE > > =SUM((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A"))) > > Or SUMPRODUCT > =SUMPRODUCT((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A"))) > > Rgds, > [dp] > > Pada 02/07/2013 20:51, Chan

$$Excel-Macros$$ Re: Is it possible to hide the name manager menu?

Using Visual Studio it should be Now, is it possible to achieve this using Visual Studio Express? Pascal Baro http://multiskillz.elementfx.com -- 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 Facebook page of this forum @ https:/

Re: $$Excel-Macros$$ Display Data Format

Try..IF(E4<>"","".. insted E4>0,0..since 0 is not in time format, its given such display... Thanks!! On Mon, Jul 8, 2013 at 3:33 PM, vba wrote: > Pl share excel file. > > Thanks > > > On Mon, Jul 8, 2013 at 3:18 PM, Ashish Kumar wrote: > >> Dear Seniors, >> >> When I'hve put the data, the outp

Re: $$Excel-Macros$$ Display Data Format

Pl share excel file. Thanks On Mon, Jul 8, 2013 at 3:18 PM, Ashish Kumar wrote: > Dear Seniors, > > When I'hve put the data, the output is reflected #, but i want data in > numbers (Time). please see attached snapshot for more clarity. kindly help > me on this. > > > Thanks > Ashish > > --

Re: $$Excel-Macros$$ payback Period Formula / Macro

Hi David, Im just getting to grips with VB; could you please let me know what Dim means? Thanks. Best On Saturday, 11 August 2012 15:56:32 UTC+4, David Grugeon wrote: > > Hi Sharad > > Use the following function in a general module. Then use =Payback(range) > > See attached > > '===