Re: $$Excel-Macros$$ age month days calculations - Reg

2012-06-23 Thread Suman
Great noorain babu..!! Regards, @Suman Send on the move with Galexy y. On Jun 23, 2012 12:09 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mothilal, If you don't want in Text Format Please use =DATEDIF(D2,E2,d) select formula cell, press ctrl+1 and type in custom yy mm dd See

RE: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

2012-06-23 Thread Rajan_Verma
Hi Amit, It will fulfil your requirement . J , See the attached. Function GetTotal(rngLookUpRange, rngMapping As Range, rngLookup As Range, lngCOlumnresult As Long, lngMinusValue As Double) As Double Dim VarMapping Dim VarLookup Dim strLookUp Dim lngResult As

$$Excel-Macros$$ Re: Introduce Yourself !!

2012-06-23 Thread hamed
hi Hamed Ajaz here, wants to learn excel know little basic but doesn't have any practical knowledge with this group and experts available here i want to learn excel Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this

$$Excel-Macros$$ Re: Join Sql statement in VB using ADODB

2012-06-23 Thread TJ
Thanks much I went ahead a copied that into the Editor and it looks like it added a few quotes and arranged some things automatically. Assume some sort of autocorrect mechanism. Ran it and it threw a Run Time error '424': Object Required on the VV_VESSEL_VISIT.VESSEL_ID ,

Re: $$Excel-Macros$$ Re: Join Sql statement in VB using ADODB

2012-06-23 Thread David Grugeon
I thought SQL required all statements to end in a semicolon ?? On Sunday, 24 June 2012, TJ wrote: Thanks much I went ahead a copied that into the Editor and it looks like it added a few quotes and arranged some things automatically. Assume some sort of autocorrect mechanism. Ran it and it