Re: $$Excel-Macros$$ Excel - Array Help

Dear Amit, I think SAM explaination is the better way to understand this part ($A$2:$A2=A2)*($B$2:$B2=B2))>1 On Sat, Jan 28, 2012 at 2:13 PM, Amit Desai (MERU) wrote: > Thanks Noorain, > > ** ** > > I have just seen your email... > > ** ** > > I understand the formula...only part i am n

RE: $$Excel-Macros$$ IS THERE ANY OTHER EQUATION TO DO LIKE THIS.

Hello Mohammed, =B3*12.5% is the same result as =B3*(12.5/100) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: Sunday, January 29, 2012 9:03 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ IS THERE ANY OT

Re: $$Excel-Macros$$ Excel - recording macro - help

Thanks Noorain, it answers my question. On 30/01/2012, NOORAIN ANSARI wrote: > Dear Amar, > > Please read below link... > > http://answers.yahoo.com/question/index?qid=20090412162945AA8ajPZ > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Excel - recording macro - help

Dear Amar, Please read below link... http://answers.yahoo.com/question/index?qid=20090412162945AA8ajPZ -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Excel - recording macro - help

Hi Noorain, Thanks for your email. Calc was just an example, I just wanted to know if I can see the code ... which is recorded outside the excel scope. is it possible? Thanks, Amar On 30/01/2012, Kasireddy Amarender wrote: > Dear all, > > My question may be strange and silly but I thought I'l

Re: $$Excel-Macros$$ Excel - recording macro - help

Dear Amar, You can usesimple code Sub cal_open() VBA.Shell ("Calc") end Sub See attached sheet... On Mon, Jan 30, 2012 at 11:26 AM, Kasireddy Amarender wrote: > Dear all, > > My question may be strange and silly but I thought I'll spell it > > Can I record the macro outside the excel

$$Excel-Macros$$ Excel - recording macro - help

Dear all, My question may be strange and silly but I thought I'll spell it Can I record the macro outside the excel ? For example, I'll start the macro recording and then minimize all my applications and open calculator and then use some maths like 2+2, can I see the code in my macro all th

Re: $$Excel-Macros$$ Adding an Item to a Collection within a Dictionary

A dictionary object has keys and items. It does not have collections AFAIK. Could you explain a bit more what you want? On 28 January 2012 06:39, IF wrote: > I am trying to add an item to a specific collection within a dictionary. > I am not sure how to do this. Any ideas? Thank you. > > --

$$Excel-Macros$$ IS THERE ANY OTHER EQUATION TO DO LIKE THIS.

Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered

Re: $$Excel-Macros$$ By Default 2003

2012/1/30 > Hi , > please install ms office lower version after higher version this problem > get resolved. > I mean reinstall 2003. Your excel files will be opened in 2003. > -- > Regards, > venkat > Chennai > Sent from my Nokia phone > > --Original message-- > From: SAJID MEMO

Re: $$Excel-Macros$$ By Default 2003

Hi , please install ms office lower version after higher version this problem get resolved. I mean reinstall 2003. Your excel files will be opened in 2003. -- Regards, venkat Chennai Sent from my Nokia phone --Original message-- From: SAJID MEMON To: "Sundarvelan Natarajan" Da

RE: $$Excel-Macros$$ about set focus event

Thanks for posting a useful, practical application, Noorain. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Sunday, January 29, 2012 9:41 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ about set focus event

Re: $$Excel-Macros$$ Hours calculate highlighted colum

See attached sheet. On Sat, Jan 28, 2012 at 12:42 PM, yasir_shahjee wrote: > Respected Masters, > > Kindly check attached sheet. i need Time calculate in Hours. hopefully its > really easier for Masters. > > > thanks > > -- > Yasir Waheed > Factory Manager > Sinopak Extrusion Technologies (Pvt.)

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

try Option Explicit Sub Look2() Dim mf As Range Set mf = Sheet2.Columns("D").Find(What:=Range("b4"), _ LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _ searchDirection:=xlNext, SearchFormat:=False) If Not mf Is Nothing Then MsgBox mf.Row End Sub Don Guillett SalesAid Software

Re: $$Excel-Macros$$ By Default 2003

Hi Sajid, Providing xlStart folder on behalf of Yogananda:- C:\Program Files (x86)\Microsoft Office\Office14\XLSTART Though I have not tried it, above is the path of Office 2010 taken in Windows 7 environment, but you can figure out at your system using above as reference. Thanks. Regards, DIL

Re: $$Excel-Macros$$ By Default 2003

HI Sajid, just right click in any excel sheet and go properties then change open with - click to change button then program file folder in (c drive) then Microsoft office folder then microsoft office2003 or office11 folder then select excel.exe then ok HI On Sun, Jan 29, 2012 at 1:25 PM, yogana

Re: $$Excel-Macros$$ By Default 2003

Hi Right click on Start > Explorer > Tools > Folder Options > File Types > Select XLS and click on change > OK. Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Co

Re: $$Excel-Macros$$ Hours calculate highlighted colum

Dear Yasir, Please find the attachment .. formula : - =(INT(D3)+E3)-(INT(B3)+C3) On Sat, Jan 28, 2012 at 12:42 PM, yasir_shahjee wrote: > Respected Masters, > > Kindly check attached sheet. i need Time calculate in Hours. hopefully its > really easier for Masters. > > > thanks > > -- > Yasir Wa

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

yes dilip, i guess u r right. i want the results as per the results highlighted in red border. and hyperlink format in red font. regards, Avinash On Sun, Jan 29, 2012 at 12:31 PM, Dilip Pandey wrote: > Hi Avinash, > > Not entirely getting your point. > Please confirm if you need following <

Re: $$Excel-Macros$$ By Default 2003

Hi, this is simple way to do. Go to XLstartup folder and delete excel 2007 icon. So default excel 2003 opens. i m travelling . so cannot provide the exact path where xlstartup exist. Try this if not possible one more solution is there.. On 1/29/12, Dilip Pandey wrote: > Hi Sajid, > > I h