Re: $$Excel-Macros$$ Need rank formula

plz resend file corrupted       From: MURALI NAGARAJAN To: excel-macros@googlegroups.com Sent: Wednesday, May 2, 2012 11:00 AM Subject: $$Excel-Macros$$ Need rank formula Dear experts. I need rank formula for attached file. Thanks in advance Thanks&Regards

RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

P.S. My comment about the constants may be important and relevant. The behavior of your code with undefined constants is quite possibly quite different than what your code appears to do. If you don't set a reference to the Scripting library, your constants will all be undefined. If you use

RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

Hi Pascal, Actually, my feeling is that your code is leaving a file handle open unneccesarily and you are having a file sharing/locking violation on FAT32 volumes -- since you only need to have one file handle open at a time, your code should be correctable (unless VBSCRIPT has some strange bug).

Re: $$Excel-Macros$$ Multi Combo Box

Or, a double click macro if not intersect((.. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Rajan_Verma Sent: Tuesday, May 01, 2012 8:39 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Multi Combo Box HI Chandru, File size will be very lar

Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

Hi, I meant magnetic hard drive...based on the fact both are rotational and that myself I was looking for my glasses while writing this post :) , I mixed them up... Btw, from latest experiments (i wasn't part of it, i'm not a scientist nor do i know about it in detail), nothing travels faster t

Re: $$Excel-Macros$$ Multi Combo Box

No you would not like this Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Chandra Shekar Sent: Tuesday, May 01, 2012 8:22 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Multi Combo Box Hello, I would like to have multi combo box on every row (100

RE: $$Excel-Macros$$ Multi Combo Box

HI Chandru, File size will be very larege with 1000 controlls on worksheet.. I suggest to use List Validation on each cell in your range Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra

$$Excel-Macros$$ Multi Combo Box

Hello, I would like to have multi combo box on every row (1000 rows). Could you please help me out on this. Thanks in advance. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, U

Re: $$Excel-Macros$$ Re: Find column # of first value greater than specified value?

IF(SUMPRODUCT((B8:AE8<>1)*B8:AE8)<1,"down","up") Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Filip Houdek Sent: Monday, April 30, 2012 10:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Find column # of first value greater than specified

Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

DVD http://en.wikipedia.org/wiki/Optical_disc_drive A optical drive is essentially what you put CD's DVD's and install discs into Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Monday, April 30, 2012 8:44 PM To: excel-macros@googlegroups.com Su

RE: $$Excel-Macros$$ Fixing the problem

Hi Dhanesh, =SUMIFS(F3:R3,F2:R2,">="&B3,F2:R2,"<="&C3) will total the periods whose date (as specified in row 2 -- appears to be month-ending date) falls between the specified dates in B3 and C3. =COUNTIFS(F2:R2,">="&B3,F2:R2,"<="&C3) will count the number of periods that actually appear in

Re: $$Excel-Macros$$ Fixing the problem

Can you explain a bit more, like how it is and how it shud be with example On Tue, May 1, 2012 at 1:53 PM, Dhanesh Verma wrote: > Dear Friends, > > ** ** > > I want to put a formula in the attached sheet to calculate automatically > as and when I change the periods., please help.. > > **

$$Excel-Macros$$ Fixing the problem

Dear Friends, I want to put a formula in the attached sheet to calculate automatically as and when I change the periods., please help.. Rgds Dhanesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

Re: $$Excel-Macros$$ Help required on how to create iterative formula

Dear David, Thanks for your response. Row 7 - "d oth all" is always a balancing number arrived on calculation. This is one of the place where it goes in circular reference The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? - I have changed

$$Excel-Macros$$ Re: Custom functions not being performed on "L39", but they are performed on "L40-L42"

Asa - thanks again. I am busy this morning revisiting, rewriting and retesting all of the code in my project after your suggestions. I strongly believe in good practice and I'm grateful to you for helping me to improve in this area. Best regards, Anil On Tuesday, April 24, 2012 11:12:56 AM U

Re: $$Excel-Macros$$ Query.

Thanks... On Tue, May 1, 2012 at 12:25 PM, Shaik Waheed wrote: > Hi, > > PFA > > > > On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar < > kumar.pramod03i...@gmail.com> wrote: > >> Hi Experts, >> PLease solve my query. >> >> I need age betbeen in two dated like as ""2 year 3 Month) >> >> -- >> Reg