Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT

2011-02-09 Thread Amir Khan
This is a very important tool to convert no. in figures into words: STEPS: 1) Download the attachment and save it to hard disk. 2) Open excels and goes to Tools -Add Ins 3) Go to browse and select the smb.xla file from the location where u saved it and click OK. USE the Formula =ntow

Re: $$Excel-Macros$$ help pls : find first non empty row in range

2011-02-09 Thread pawel lupinski
thanks a lot!!! superb From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, February 9, 2011 5:33:44 AM Subject: Re: $$Excel-Macros$$ help pls : find first non empty row in range check the attachment On Wed, Feb 9, 2011 at

Re: $$Excel-Macros$$ help pls : find first non empty row in range

2011-02-09 Thread pawel lupinski
thanks!!! From: danial mansoor danial_...@hotmail.com To: excel-macros@googlegroups.com Sent: Wed, February 9, 2011 4:02:58 AM Subject: RE: $$Excel-Macros$$ help pls : find first non empty row in range use this formula with NOT ONLY PRESS ENTER,PRESS

RE: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

2011-02-09 Thread Dave Bonallack
Thanks Ashish, Works great. Regards - Dave. Date: Wed, 9 Feb 2011 10:32:26 +0530 Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64 From: koul.ash...@gmail.com To: excel-macros@googlegroups.com try this On Wed, Feb 9, 2011 at 10:27 AM, ashish koul

Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

2011-02-09 Thread ashish koul
hi dave check this link see if helps http://itknowledgeexchange.techtarget.com/beyond-excel/back-to-controlling-the-cursor/ On Wed, Feb 9, 2011 at 2:08 PM, Dave Bonallack davebonall...@hotmail.comwrote: Thanks Ashish, Works great. Regards - Dave. -- Date: Wed,

$$Excel-Macros$$ Excel Charts/Pivots/VBA Newsletter

2011-02-09 Thread OpenExcel.com
Hey Friends, Here is something interesting for you. *Love is in the air*, do some automation and *save your time for your loved ones*. Hope this helps you :) 1. Collection of VBA Macroshttp://www.excelitems.com/2008/09/vba-macro-codes-examples-collection.html 2. Access a search Engine like

RE: $$Excel-Macros$$ Excel Charts/Pivots/VBA Newsletter

2011-02-09 Thread Tolontino Gomes
Can some one help me in the following problems with excel 2003? When I save file a .tmp file saves and when I delete again .tmp saves along with the orginal .xls file Please help Reply me on tolontino.go...@pepsidrc.aemailto:tolontino.go...@pepsidrc.ae

$$Excel-Macros$$ Shorting Problems

2011-02-09 Thread sudhir kumar
Dear Frnd I have list which have many repeated names i want short it with formula thanx -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * *Happy

Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

2011-02-09 Thread rcamarda
Sorry for the rabbit hole...I posted too quickly and once it was sent, I couldnt retract. I still can not get it to work. Latest I tried is this, which always says left click has been pressed code: On a module I have: Public Declare Function GetAsyncKeyState Lib user32 (ByVal vKey As Long) As

Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

2011-02-09 Thread ashish koul
can you share your workbook On Wed, Feb 9, 2011 at 6:57 PM, rcamarda robert.a.cama...@gmail.com wrote: Ashish, 1. Your code worked from your example. 2. in my other tests, I added added the = 1 I had, and some of my test sheets worked. 3. It didnt work when i put it into my sheet where I

Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

2011-02-09 Thread ashish koul
r u using right button also On Wed, Feb 9, 2011 at 7:53 PM, ashish koul koul.ash...@gmail.com wrote: can you share your workbook On Wed, Feb 9, 2011 at 6:57 PM, rcamarda robert.a.cama...@gmail.comwrote: Ashish, 1. Your code worked from your example. 2. in my other tests, I added added the

Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

2011-02-09 Thread rcamarda
Im not using the right mouse. If you suggest that I use the right mouse, I'd need to disable the format popup if I am in my target cell. IE If Target.Count = 1 and Target.Column = 34 and Target.Value 0 And (GetAsyncKeyState(vbKeyLButton) = 1 And H8000) Then ' my logic End If On Feb 9, 9:25 am,

Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

2011-02-09 Thread rcamarda
Here it is (I used the new google groups ) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

Re: $$Excel-Macros$$ Shorting Problems

2011-02-09 Thread Umesh Dev
Hi Sudhir, Select the row A = Click on Data Tab = Click on Advanced = Select Unique Records Only. That's it. Regards Umesh On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Frnd I have list which have many repeated names i want short it with formula thanx

Re: $$Excel-Macros$$ Shorting Problems

2011-02-09 Thread Vikas Chouhan
Hi Sudhir, please find the attachment and check it, On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Frnd I have list which have many repeated names i want short it with formula thanx -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before

$$Excel-Macros$$ Question for you Excel Masters out there...

2011-02-09 Thread MikeMikeMike
Greetings, I have a question I am hoping to find the answer of here... I have a spreadsheet that signifies that includes revenue which is represented on my pivot charts as bars represented by a month (a good example but I could come up with others of course). Simple enough right? Well what if I

Re: $$Excel-Macros$$ Passing Variable to another function

2011-02-09 Thread hanumant shinde
Hi Paul, Sorry for late reply as i was out of town i couldnt check this out. Thanks a lot paul for your detail explanation.and really sorry for creating confusion. my que is Can a variable be passed to a function without initializing it and getting their values. i have explained in detail