Re: $$Excel-Macros$$ Macro is not working

members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@goog

Re: $$Excel-Macros$$ Want to count unique values from duplicate , by VBA or formula please help shiv..

A MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros.

Re: $$Excel-Macros$$ Click Button on URL using VBA

mentByid("gb_70").Click End With End Sub On Thu, Aug 25, 2016 at 7:28 AM, Emamuddin Shah <emt...@gmail.com> wrote: > Thanks Gaurav, but I don't want to navigate I want it to click that button. > On Aug 25, 2016 6:40 PM, "Gaurav Devrani" <gauravdev1...@gmail.c

Re: $$Excel-Macros$$ Click Button on URL using VBA

st solutions... I just started vba crawling > On Aug 25, 2016 6:17 PM, "Gaurav Devrani" <gauravdev1...@gmail.com> wrote: > >> Please disregard my email. >> >> On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah <emt...@gmail.com> wrote: >> >&g

Re: $$Excel-Macros$$ Click Button on URL using VBA

. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this grou

Re: $$Excel-Macros$$ Click Button on URL using VBA

d > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+uns

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

. Please check and > advise. > > > *With regards,**Pravin Gunjal* > *Mobile: 77100 * > *97250* > > > > > On Wed, Aug 17, 2016 at 4:05 PM, Gaurav Devrani <gauravdev1...@gmail.com> > wrote: > >> Hi Pravin, >> >> I think this query was alread

Re: $$Excel-Macros$$ Copy Paste Problem

to understand your query. If those are multiple excel files , you can also create a loop on those files using FSO (File system object) and copy that data. Let me know. Waiting for your response Shrini. Regards Gaurav Devrani On Wed, Aug 10, 2016 at 12:40 AM, Shrinivas Shevde <shrinivas...@gmail.

Re: $$Excel-Macros$$ Copy Paste Problem

, then you need to write code to do that process and just paste that data in column A in the attached file that i sent earlier. you can check that code in case you want to know about the range where code is running, Let me know if i am not able to answer your question. Regards Gaurav Devrani 8586932754

Re: $$Excel-Macros$$ Copy Paste Problem

Hi Shrini, Please check the attached file. Let me know if this does not solve your query. Regards Gaurav Devrani On Tue, Aug 9, 2016 at 1:37 AM, Shrinivas Shevde <shrinivas...@gmail.com> wrote: > Dear all > I have data in Column A in 1to 6 rows . I want to copy paste

Re: $$Excel-Macros$$ MSG: Code execution has been interrupted

ot;MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/gr

Re: $$Excel-Macros$$ RE: Help required

. For more options, visit https://groups.google.com/d/optout. -- *Thanks Regards* *Gaurav Devrani* -- 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 RULES 1

Re: $$Excel-Macros$$ Re: Populating rows using a range of data

Hi , Please check the attached file. Regards Gaurav Devrani On Wed, Apr 15, 2015 at 3:54 PM, Umar Abeer umarab...@googlemail.com wrote: Hi Mandeep, Many thanks. It serves the purpose but is there any way we can use index/match or any range formula to achieve the same? BR Aby On Wed

$$Excel-Macros$$ Urgent Help

of the data except Pivot. To access pivot table data i need a macro to ask for password and then only I should be able to get access of pivot. If it does not make any sense.. Please let me know. i will explain again. Help me Guys.. -- *Thanks Regards* *Gaurav Devrani* -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ Query for autofit columns.

Hi Mandeep, Please check the attached file. let me know if I am missing something. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja mandeepbal...@gmail.com wrote: Quuery for autofit -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME

Re: $$Excel-Macros$$ Please help me Urgent

!! On Thu, Feb 26, 2015 at 8:42 PM, Gaurav Devrani gaurav...@gmail.com wrote: Hi Guys, I have a query . In this sentence.. This iS a tEst . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel

Re: $$Excel-Macros$$ Formula based on some criteria

Hi Rameshwari , Please check the file. Let me know if it does not work for you. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 5:47 PM, Rameshwari rameshwarish...@gmail.com wrote: Hello team, I stuck with one formula, please help me on this. Formula based on some criteria. Sheet

Re: $$Excel-Macros$$ Query for autofit columns.

March 2015 14:37:51 UTC+5:30, Gaurav Devrani wrote: Hi Mandeep, Please check the attached file. let me know if I am missing something. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja mandee...@gmail.com wrote: Quuery for autofit -- Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ Excel VBA to hide sheets of a workbook closes others too

I am sure that in your code Index is referring to the sheet name that you want to unhide. Regards Gaurav Devrani On Wed, Mar 4, 2015 at 7:34 AM, Yahya Muhammad yahya...@gmail.com wrote: Dears Any solution, please ! On Mon, Mar 2, 2015 at 11:24 AM, Yahya Muhammad yahya...@gmail.com wrote

Re: $$Excel-Macros$$ Please help me Urgent

Hi Paul, Thanks for the amazing macro you sent. it worked like a charm.. Thanks again. Regards Gaurav Devrani On Fri, Feb 27, 2015 at 1:04 AM, Paul Schreiner schreiner_p...@att.net wrote: Are you wanting a macro made to work like a function? Like: =CaseSwap(A1) where CaseSwap

Re: $$Excel-Macros$$ Please help me Urgent

Thanks Paul for your quick reply. Yes I was also trying to create a macro but Just wanted to confirm before, if that's possible in excel functions. No worries. I really appreciate your quick response once again. Thank you. Regards Gaurav Devrani On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner

$$Excel-Macros$$ Please help me Urgent

Hi Guys, I have a query . In this sentence.. This iS a tEst . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel formulas.(If thats possible). Thanks Regards Gaurav Devrani -- Are you =EXP

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Hi , I guess you also want to merge the header cells in sheet 2 for all entries.. Please refer to this new sheet. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: HI Enock, Please check the attached file and let me know if I missed

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Yes Sure.. I will get back to you with that formula. No worries. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Gaurav, Thank you for you help. Quick question, is there a way of using a formula instead of a code to do what you have done

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered

Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Try this in B5 of sheet2 and drag right. =IF((COLUMN()-1)=Sheet1!$B$3,Sheet1!$B$2,IF((COLUMN()-1)=Sheet1!$B$3+1,SUM(OFFSET($A$5,,1,,Sheet1!$B$3)),)) On Mon, Feb 23, 2015 at 7:29 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Yes Sure.. I will get back to you with that formula. No worries

Re: $$Excel-Macros$$ Excel Tip

Superb Vaibhav. Thanks for sharing this with us. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 11:25 PM, Chandan Bisht csb.bi...@gmail.com wrote: Hi. Very nice... Thankx Rgds, Chandra Singh Bisht On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi v...@vabs.in wrote: Convert all date

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

okay... Thanks Vaibhav. On Sat, Feb 14, 2015 at 5:43 AM, Vaibhav Joshi v...@vabs.in wrote: I mean free file.. On Fri, Feb 13, 2015 at 8:39 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi Vaibhav, What is FF? Can you please tell me ? Dont have any idea about that please. On Fri

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

Hi Vaibhav, What is FF? Can you please tell me ? Dont have any idea about that please. On Fri, Feb 13, 2015 at 8:04 AM, Vaibhav Joshi v...@vabs.in wrote: Cheers, also you could have created FF save it as .doc. On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani gauravdev1...@gmail.com wrote

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Thaks for the complete answer, it works like a charm! On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

://groups.google.com/d/optout. -- Thanks Regards Gaurav Devrani -- 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 RULES 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Gaurav Devrani gauravdev1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, February 2, 2015 3:01 PM *Subject:* Re

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

.♣♣♣* On Mon, Feb 2, 2015 at 5:58 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: And Please check the filter again. I guess I dint put that filter on the entire sheet. Please select true values as well and then filter it again. Sorry for the wrong file. On Mon, Feb 2, 2015 at 5:24 AM

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

And Please check the filter again. I guess I dint put that filter on the entire sheet. Please select true values as well and then filter it again. Sorry for the wrong file. On Mon, Feb 2, 2015 at 5:24 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: :) On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

, visit https://groups.google.com/d/optout. -- Thanks Regards Gaurav Devrani -- 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 RULES 1) Use concise

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

:) On Mon, Feb 2, 2015 at 5:22 AM, Vaibhav Joshi v...@vabs.in wrote: Great Tip by Gaurav.. On Mon, Feb 2, 2015 at 5:49 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Please check the attached file, Let me know If I am missing on something. I guess you were trying to copy only those

Re: $$Excel-Macros$$ multi mailer

. Thanks. Thanks Gaurav On Mon, Feb 2, 2015 at 10:04 PM, Anil Gawli gawlianil8...@gmail.com wrote: Dear Gaurav, Pls share the file regards, Anil On Tue, Feb 3, 2015 at 10:25 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Can anyone help me on this? I have a specific data and want to send

$$Excel-Macros$$ multi mailer

Can anyone help me on this? I have a specific data and want to send that data to multiple recipients (have around 50 emails) but when i run my macro. It sends them individually instead of sending in a single Email. So much time consuming. Is there anyway to get it fixed.(like; Cc, Bcc for 50 or

Re: $$Excel-Macros$$ Wish u all A Merry Christmas

this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Thanks Regards Gaurav Devrani -- 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