Dear Rajan, I would be thank ful for your help. But I m not getting how exactly to run this VBA code in my required Excell Work Book. Can u help me.......?
Regards, Saroj On Mon, May 23, 2011 at 8:20 PM, rajan verma <rajanverma1...@gmail.com>wrote: > Amended.. > > Function Ratio2(*ParamArray* arr()) As String > For i = 0 To UBound(arr) > Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" > Next > Ratio2 = Left(Ratio2, Len(Ratio2) - 1) > End Function > > On Mon, May 23, 2011 at 8:16 PM, rajan verma <rajanverma1...@gmail.com>wrote: > >> *Try this Function* >> >> Function Ratio2(*ParamArray* arr()) As String >> Dim Arr2(1) As Integer >> For i = 0 To UBound(arr) >> Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" >> Next >> Ratio2 = Left(Ratio2, Len(Ratio2) - 1) >> End Function >> >> >> On Mon, May 23, 2011 at 12:35 PM, Kabir....:-) <saroj.32...@gmail.com>wrote: >> >>> Dear Rajan, >>> >>> Thanks for your formula....it works. But I want to know, will there be >>> any macro or VBA code for the query like this. Kindly help me if anything >>> available like such. >>> >>> Thank you all........... >>> >>> Regards, >>> >>> Saroj. >>> >>> On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma >>> <rajanverma1...@gmail.com>wrote: >>> >>>> Hi Kabir, >>>> >>>> See if it help. >>>> >>>> >>>> >>>> *From:* excel-macros@googlegroups.com [mailto: >>>> excel-macros@googlegroups.com] *On Behalf Of *Kabir....:-) >>>> *Sent:* Friday, May 20, 2011 5:09 PM >>>> *To:* excel-macros@googlegroups.com >>>> *Subject:* $$Excel-Macros$$ Need a formula for getting the output of >>>> one calculation as RATIO >>>> >>>> >>>> >>>> Dear Gurus, >>>> >>>> I need a formula for calculated two numbers and resulted output should >>>> be in a Ratio.i.e., 2:1 or 1.5:3. >>>> >>>> Thank you in advance, >>>> >>>> Regards, >>>> >>>> Saroj. >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> 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 @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> 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 @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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 @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> Regards >> Rajan verma >> +91 9158998701 >> > > > > -- > Regards > Rajan verma > +91 9158998701 > > -- > > ---------------------------------------------------------------------------------- > 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 @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel