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.
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
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
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
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,
>
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
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
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
>>
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
>
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
10 matches
Mail list logo