Re: $$Excel-Macros$$ number spliting formula

2012-03-01 Thread Kabir....:-)
Dear all., We can take either NOW() or TODAY(), but those has to be paste special by values and then we can use RIGHT() or LEFT() with our required values and then redo the paste special by values and that cell has to be formated by appropriate function. This may help.please try if u feel Ok.

Re: $$Excel-Macros$$ help Please

2011-05-04 Thread Kabir....:-)
Dear Mahesh, May i know how this is possible. I want to learn it. Thanks in advance. Regards, Saroj. On Tue, May 3, 2011 at 10:58 PM, Mahesh parab wrote: > Hi > check attach, whether its as per u r requirement > > On Tue, May 3, 2011 at 8:29 PM, m7md.gmail wrote: > >> all, >> please i need

Re: $$Excel-Macros$$ Re: delete workbook if password is not entered

2011-05-06 Thread Kabir....:-)
Dear Mr. Golden Lance, When i m copying the code and executing in the new workbook, the following error is showing. Kindly help me. *Compile error : syntax error* Regards, Saroj. On Thu, May 5, 2011 at 10:17 PM, GoldenLance wrote: > Thanks for highlighting my mistake C.G.Kuma

$$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

2011-05-20 Thread Kabir....:-)
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 o

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

2011-05-23 Thread Kabir....:-)
Dear Rajan, Thanks for your formulait 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 wrote: > Hi Kabir, >

Re: $$Excel-Macros$$ Help on Transpose Function based upon criteria

2011-05-23 Thread Kabir....:-)
Dear Kaushik, I am having a small doubt pertaining to your solution given for transpose formula. When i look into the sheet, the claim no. 1 shows the Amount of 10, 10, 50 & 20 was been given. But as per your formula, the Amount of 10, 30 & 20 has got transpose to the Claim NO.1. Where as Amount R

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

2011-05-23 Thread Kabir....:-)
Dear Noorain, I will be thankful for your effort on my request. Regards, Saroj. On Fri, May 20, 2011 at 10:39 PM, NOORAIN ANSARI wrote: > Pls try it > > =CONCATENATE(A1,":",B1) > > On Fri, May 20, 2011 at 5:08 PM, Kabir:-) wrote: > >> Dear

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

2011-05-24 Thread Kabir....:-)
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 >>

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

2011-05-24 Thread Kabir....:-)
ue, May 24, 2011 at 2:12 PM, Kabir:-) wrote: > >> 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 >

Re: $$Excel-Macros$$ Excel-Macros for protecting cell

2011-08-02 Thread Kabir....:-)
Dear Lucky Ji., Thanks for your valuable help. I am having a requirement of protecting the entire sheet. The query is - How should i lock a particular book with a pass word. When ever a user tries to open that work book it has to be asked password. Then only the sheet should open and the contents