Re: $$Excel-Macros$$ Sumproduct using VBA

hi To insert sumproduct formula thru VBA you by using evaluate. Pl refer http://www.xldynamic.com/source/xld.SUMPRODUCT.html HTH//Cheers On Fri, Jul 12, 2013 at 7:17 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Could you please let me know how to use sumproduct using VBA?

Re: $$Excel-Macros$$ group dates into months

Hi Pl refer. http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/ Thanks On Friday, July 5, 2013 6:03:30 PM UTC+5:30, Krishnaraddi V. Madolli wrote: Does anyone know how to group dates into months in a Pivot table in Excel *2003*? Regards, Krishnaraddi V Madolli.

$$Excel-Macros$$ how are you?

http://redwood-hotel.com/qvm/syfyvhrfeh prasadpain 7/21/2013 2:00:21 PM -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

$$Excel-Macros$$ Query - How to make reversal string.

Dear Seniors, I have this type of data : 54321 ASDF 8796564 DFRESW But I want OUTPUT like below mentioned : 12345 FDSA 4656978 WSERFD How to make ti reversal through formula. Please help ?? Thanks Regards, Ashish Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Export Excel Data Into Outlook email template

hi visit this link http://www.rondebruin.nl/win/s1/outlook/mail.htm you will find multiple options for sending email automatically using macros On Sat, Jul 20, 2013 at 6:54 PM, dynamitekicker dynamitekic...@gmail.comwrote: Thanks Ashish! Word mail merge is a satisfactory solution, but

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Ashish sir, thanks for your quick response, but this is not working i want solve this query only from excel formula not VbA. coz, i want to reverse string in some columns not whole excel sheet. please suggest me how to resolve this query from excel formula. Thanks, Ashish On Sunday,

Re: $$Excel-Macros$$ Query - How to make reversal string.

Hi Ashish, Try this Function Reverse(Text As String) As String Dim i As Integer Dim StrNew As String Dim strOld As String strOld = Trim(Text) For i = 1 To Len(strOld) StrNew = Mid(strOld, i, 1) StrNew Next i Reverse = StrNew End Function

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Vabs, Thanks for you reply, the formula is working but when I change this formula accordingly this is not working properly. please find attached excel sheet for query data. On 21 July 2013 21:20, vba v...@vabs.in wrote: Hey, Try this, this works up to 12 character.

Re: $$Excel-Macros$$ Query - How to make reversal string.

PFA Thanks On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Vabs, Thanks for you reply, the formula is working but when I change this formula accordingly this is not working properly. please find attached excel sheet for query data. On 21 July 2013

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear VbA, thanks for your help. but this formula is not working properly. Thanks, Ashish On 22 July 2013 10:27, vba v...@vabs.in wrote: PFA Thanks On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Vabs, Thanks for you reply, the formula is