Re: $$Excel-Macros$$ Need Help!

As per my observation this is producing wrong result, please check it once again. On Fri, Apr 8, 2011 at 9:34 AM, §»VIPER«§ viper@gmail.com wrote: hi syed, find the attached without array. -- *Thanks Regards Thamu * On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim

Re: $$Excel-Macros$$ regd: drop down button

Why are you using this lengthy formula? =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0)) instead of =INDIRECT($B$15) (Working Fine as above one) On Sun, Feb 27, 2011 at 10:19 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Naresh, Please check the attached file for required solution. I have used

Re: $$Excel-Macros$$ Creating directories

good On Wed, Feb 23, 2011 at 11:13 AM, Harmeet Singh harmeet.hew...@gmail.comwrote: I Hope this will help. Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Wed, Feb 23, 2011 at 4:03 PM, ashish koul

Re: $$Excel-Macros$$ Formula

Good Formula! Please brief its logic especially about 2. On Sun, Jan 16, 2011 at 10:27 AM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi John, It will work in version 2003 if you refer the cell reference to part of the column range instead of referring it to the whole column.

Re: $$Excel-Macros$$ how to get month Occurrence in no.

Really Impressive! Let me know how this formula works On Tue, Dec 28, 2010 at 3:43 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, A shorter version would be: =MONTH(--(1A1)) This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended abbreviations (eg Sept) and

Re: $$Excel-Macros$$ Amount Format

Good. On Tue, Dec 28, 2010 at 7:39 PM, Daniel dcolarde...@free.fr wrote: Please, see attached file. Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Rajiv Kumar Envoyé : lundi 20 décembre 2010 15:11 À :

$$Excel-Macros$$ Execute a macro while attaching to send

workbook remain unsaved. how can i determine through VBA when send as attachment command save workbook temporarily. Waiting for A Good solution. Thanks. Sajid Mansoor -- -- Some important links for excel users: 1

Re: $$Excel-Macros$$ time running

Very Good! On Thu, Nov 18, 2010 at 12:55 PM, johnson john johnsond...@gmail.comwrote: just try this., Sub Y_1() Range(a1) = Format(Now(), HH:MM:SS) Application.OnTime Now() + TimeValue(00:00:01), Y_1 End Sub Best regards., On Thu, Nov 18, 2010 at 12:50 PM, siti Vi

Re: $$Excel-Macros$$ Please help regard this question

Very simple! Good On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Jai... Please see attachment.. =TEXT(D5-D6,YY )YEAR, TEXT((D5-D6),mm) MONTH, TEXT((D5-D6),dd) DAYS Thanks, Noorain On Thu, Nov 11, 2010 at 9:47 PM, Jai jaihumtu...@gmail.com wrote:

Re: $$Excel-Macros$$ data cleaning in excel

Good! On Sun, Dec 13, 2009 at 6:01 PM, Dilip Pandey dilipan...@gmail.com wrote: Ok, The solution is revised as per your needs. One thing the data scenario given by you has some conflict. Explained below:- 11/1/09 123456 - duplicate 10/19/09123456 -

Re: $$Excel-Macros$$ Removing or extracting lettres from List in Excel

I think your solution is best. On Wed, Dec 23, 2009 at 3:18 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Gobet, Use following formula in the column B and drag it down. =RIGHT(A2,LEN(A2)-FIND(@,A2)+1) solved workbook is also attached. Thanks -- DILIP KUMAR PANDEY MBA-HR,B

Re: $$Excel-Macros$$ Re: help in understanding code

Very Good Information! On Fri, Oct 22, 2010 at 1:33 PM, Ashish Jain 26may.1...@gmail.com wrote: Hi Omar Here is line by line description of the VBA code you provided: Sub OMAR_QUERY() 'Error Handling ON: In case of error, it will skip to next line. On Error Resume Next 'Error

Re: $$Excel-Macros$$ Running Count for particular data

Good! On Tue, Jul 6, 2010 at 8:55 AM, WizExcel ssw...@gmail.com wrote: This is just too good Ayush , thanks for the explanation. On Jul 5, 8:16 pm, Ayush jainayus...@gmail.com wrote: Thanks Ankit. As the running count was required, The formula should have running range. I have used

Re: $$Excel-Macros$$ Problem in list box when using refedit control

it's not working... On Sun, Jul 4, 2010 at 3:03 PM, ayush jain jainayus...@gmail.com wrote: Hi Neil, As there are multiple items in a range, You need to use FOR EACH statement to add items of range one by one in listbox. Attached is the solution for your reference. I hope it helps. Please

Re: $$Excel-Macros$$ Fwd:

Very Good! On Sat, Jul 3, 2010 at 2:15 PM, ashish koul koul.ash...@gmail.com wrote: Thanks a lot Dave. On Sat, Jul 3, 2010 at 2:22 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, A1 = *United States of America* =FIND(CHAR(1),SUBSTITUTE(A1,

Re: $$Excel-Macros$$ Hi, need your help - urgent

Good! But instead of copy paste we can use bring to front by keeping all images on same position. On Thu, Jul 1, 2010 at 7:38 PM, ashish koul koul.ash...@gmail.com wrote: hi Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If ActiveCell.Row = 2 And

$$Excel-Macros$$ EXCEL count in multiple sheets with criteria

Please help me in attached sheet. i have 5 sheets, sheet1 to sheet5 each sheet contain 97%, 98%, 99%, 58%, 100% of recovery in Cell a respectively. Now i want to cot count only those recoveries which are above to 97%. Urgent Please. --