Please add my number 9650590467
On 8 Aug 2016 9:43 pm, "Rajeev Ranjan" <06raj...@gmail.com> wrote:
> please add the my number 9811503853
>
> On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote:
>>
>> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you
>> wants to j
Great Ravi bro. This is exactly what I wanted. Thanks for your help.
Regards,
Mukesh Kumar
On Mon, Jan 20, 2014 at 11:26 AM, Ravi Kumar wrote:
>
>
> PFA…, I guess you are looking for this. J
>
>
>
>
>
>
>
> *Warm Regards,*
>
> *Ravi Kumar.*
>
>
>
link has some
solution, but I didn't understand how to apply these codes. Please help me
out in this matter. Link is
http://www.vbaexpress.com/forum/showthread.php?19661-Showing-Formula-with-values&highlight=precedent
Regards,
Mukesh Kumar
On Sat, Jan 18, 2014 at 3:43 PM, Ravi
wrote:
> Sub test()
> Dim i As Long
>
> For i = 2 To Range("a65356").End(xlUp).Row
>
> Range("c" & i).ClearContents
> Range("c" & i).Formula = "=" & Range("a" & i).Value & "*" & Range(&quo
on other
formulas too & it would be better that on running macro, user form appears
that asks for the range where to run this macro.
Please provide help.
Regards,
Mukesh Kumar
--
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 Fac
actual requirement is that formula recalculate within formula by values
& formula can we anywhere in the sheet.
Regards,
Mukesh Kumar
On Sat, Jan 11, 2014 at 10:51 PM, ashish koul wrote:
> try this
>
> Sub test()
> Range("d2:d8").Value = Range("d2:d8").Va
Hello Experts
Please provide me solution for the query given in attached file.
Thanks & Regards,
Mukesh Kumar
--
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/discusse
taken only 31 character if text is more
> than 31 character.
>
> ** **
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar
> *Sent:* Wednesday, October 09, 2013 5:09 PM
> *To:* excel-macros@googl
Dear Sir,
Please check that there is no changes done in your attached file.
Regards,
Mukesh Kumar
On Wed, Oct 9, 2013 at 4:46 PM, Ravinder wrote:
> pfa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mu
g to dropdown list. Please
provide macro code for this.
Sample file is attached. Please note that dropdown list in this sample
file is in A7 cell. I want macro code that works on dropdown list
regardless of dropdown list position i.e it may be in any other cell in my
other files.
Regards,
Mukesh K
Rajesh Ji,
In my workbook, formulas are in range b. This macro code is working on
other ranges also. Thanks to you very much.
Regards,
Mukesh Kumar
On Fri, Sep 27, 2013 at 1:17 PM, Ravinder wrote:
> But where u want to paste those formula means which range all sheets have
> the same
Thanks a lot Rajan Ji for your help. This code is working fine.
Regards,
Mukesh Kumar
On Fri, Sep 27, 2013 at 12:03 PM, rajan verma wrote:
>
> So problem was the reference in formulas , if any formula have reference
> like A1:A5 and when it will get evaluate by VBA (i am using Eval
Rajan ji , this macro code is limited to one sheet only. I want the macro
that works upon all sheets at once.
Regards,
Mukesh Kumar
On Thu, Sep 26, 2013 at 3:39 PM, rajan verma wrote:
> HI Mukesh
>
> i have seen this query many time on this group and another forums, please
> tr
e(strFormula)
> & "*" Then
> VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC))
> lngCount = lngCount + 1
> End If
> End If
> Next lngC
> Next lngR
> ActiveSheet.UsedRange.Value = VarArr
> MsgBo
Hi experts,
I need a macro code to paste special a particular formula across many
sheets. Every sheet contains different types of formulas, but i have to
paste special a particular /specific formula.
Please help me out.
Regards,
Mukesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Thanks DP Sir, the code is now working perfectly.
Regards,
Mukesh Kumar
On Wed, Jul 17, 2013 at 6:40 AM, De Premor wrote:
> ignore my last email, i've made some change in variable declaration
> PFA
>
>
> On 17/07/2013 7:32, De Premor wrote:
>
> Hi, Muke
Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is
coming twice in result. Can it also come single time.
Regards,
Mukesh Kumar
On Tue, Jul 16, 2013 at 1:48 PM, De Premor wrote:
> Solution Attached
>
>
> On 16/07/2013 14:10, Mukesh Kumar wrote:
>
>>
Hi Experts,
I need macro /formula for query given in attached file. The result should
come based on values given in column A.
Regards,
Mukesh Kumar
--
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
Hi Experts,
I need formula (not macro code) to rearrange various column data in a
single column.
Sample file is attached herewith.
Regards,
Mukesh Kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
Thanks very very much Sam Mathai Chacko sir. This was the resultant code i
was looking for. You are marvellous in excel sir.
Thanks again.
Regards,
Mukesh Kumar
On Wed, Feb 1, 2012 at 12:01 AM, Sam Mathai Chacko wrote:
> The code I gave was exactly for assigning any number of header gro
spective of Header names or count ?
Else i feels i am unable to make clear my query to you !
Regards,
Mukesh Kumar
On Tue, Jan 31, 2012 at 11:18 PM, NOORAIN ANSARI
wrote:
> Dear Mukesh,
>
> See attached sheet
> Only procedure name is incorrect during calling under Command Bu
Dear Kris,
Following error is coming after macro execution
Run time error '9':
Subscript out of range.
Please correct it.
Regards,
Mukesh kumar
On Tue, Jan 31, 2012 at 10:00 PM, Kris wrote:
>
> Sub kTest()
>
> Dim x, ka, k(), i As Long, n As Long, c As Long
columns headings similar & other
workbooks =>5 similar column headings. So for all my workbooks, can you
guys give common macro code or formulas.
Regards,
Mukesh Kumar
On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI wrote:
> Dear Mukesh,
>
> Please see attached sheet...
> I hope
according to variable number of columns titles.
Waiting for the reply.
Regards,
Mukesh kumar
On 1/31/12, NOORAIN ANSARI wrote:
> Dear Mukesh,
>
> Please try it.. and see attached sheet.
>
> Sub mukesh()
> Dim i, c, j As Integer
> c = Application.WorksheetFunction.Cou
that here two columns are having label i.e. Name & No.
There may be certain time the columns may having more than 2 or more
labels. So please keep this situation too in mind.
Thanks & Regards,
Mukesh Kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurat
Hi Santosh,
Please find attached sheet with correction in formula.
Thanks
Mukesh
- Original Message -
From: santosh subudhi
To: excel-macros@googlegroups.com
Sent: Tuesday, November 22, 2011 1:38 PM
Subject: $$Excel-Macros$$ need correction in the formula
Hi All,
Plea
Hi Smitha,
Try below formula
=RIGHT(A1,LEN(A1)-FIND(":",A1))
Thanks
Mukesh
- Original Message -
From: smitha.kumari
To: excel-macros@googlegroups.com
Sent: Thursday, November 10, 2011 11:32 AM
Subject: RE: $$Excel-Macros$$ remove a certain text from every sentence
The re
Hi Excel Experts,
We need some data analyst, Please see below all description related to job,
Interested candidate reply me with their Resume.
Experience:
2 - 4 Years
Location: Noida
Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA
Industry Type: IT-Consult
Hi lee,
Please find attached formula for your query.
Thanks
Mukesh
- Original Message -
From: Sara Lee
To: excel-macros@googlegroups.com
Sent: Monday, October 31, 2011 6:49 AM
Subject: $$Excel-Macros$$ formulas to get the week in the month and week of
the year
hi
i h
Hi Sriram,
Please find attached solved sheet.
Thanks
Mukesh
- Original Message -
From: sriram ji
To: excel-macros@googlegroups.com
Sent: Monday, October 24, 2011 7:04 PM
Subject: $$Excel-Macros$$ Help needed..?
Dear All,
Kindly find the attached file, and provide form
Hi Excel Experts,
We need some data analyst, Please see below all description related to job,
Interested candidate reply me with their Resume.
Experience:
2 - 4 Years
Location: Noida
Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA
Industry Type: IT-Consult
Hi Anil,
Please find below my emailid
mukeshconsci...@gmail.com
Thanks
Mukesh
- Original Message -
From: anil kumar
To: excel-macros@googlegroups.com
Sent: Saturday, October 22, 2011 12:28 PM
Subject: Re: $$Excel-Macros$$ Job- Required Excel Expert
Hi Mukesh,
Plz se
Hi Excel Experts,
We need urgent some data analyst, Please see below all description related to
job,
Interested candidate reply me with their Resume.
Experience:
2 - 4 Years
Location: Noida
Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA
Industry Type: IT
Hi Excel Experts,
We need some data analyst, Please see below all description related to job,
Interested candidate reply me with their Resume.
Experience:
2 - 4 Years
Location: Noida
Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA
Industry Type: IT-Consulting Company
Hi Prathap,
Please find attached sheet, hope it will help you.
Thanks
Mukesh
- Original Message -
From: Prathap
To: excel-macros@googlegroups.com
Sent: Monday, February 28, 2011 2:28 PM
Subject: $$Excel-Macros$$ Fomula to find the Missing Numbers in the sequence
- Reg
De
Hi Puttu,
Please find attached solved sheet.
Thanks
Mukesh
- Original Message -
From: Puttu *
To: excel-macros@googlegroups.com
Cc: Rohan Young
Sent: Friday, February 25, 2011 5:37 PM
Subject: Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula
Attached is
;<><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&a
Hi amir shahzad
Plz find attached is solution.
Regards
Mukesh
On Wed, Jul 29, 2009 at 12:58 AM, Aamir Shahzad wrote:
> Dear Members,
>
> I have little issue "Series" please see attached sheet I just want to know
> how I put series if I have thousand of names. But space is problem. Kindly
> res
38 matches
Mail list logo