Re: $$Excel-Macros$$ Auto filter subtotals - names wont appear in the subtotal row - please help its driving me crazy !

2013-09-29 Thread xlstime
can u please share the output example? . Enjoy Team XLS On Sat, Sep 28, 2013 at 5:24 PM, Johnnyboy5 intermediatec...@gmail.comwrote: have a main sheet with a list of 51 unique names in Column B and then lots of data in other columns across the sheet. I have

Re: $$Excel-Macros$$ to

2013-09-29 Thread xlstime
Visit below group link http://groups.google.com/group/excel-macros. and click on Apply to joingroup . Enjoy Team XLS On Sat, Sep 28, 2013 at 10:41 AM, TIWARI tiwariin...@gmail.com wrote: dear Sir, How can make new member of excel-macros groups. -- Are you

Re: $$Excel-Macros$$ How to take the data from the webpage table and paste it in the excel

2013-09-29 Thread xlstime
Go to Data menu option and select in Get External Data From WEB and simply record macro your self. . Enjoy Team XLS On Sat, Sep 28, 2013 at 11:34 AM, Menaka Balakrishnamoorthy menaka.balakris...@gmail.com wrote: HI, I want to take the data from the webpage

$$Excel-Macros$$ Auto run multiple macros with data change

2013-09-29 Thread Warwick Trueman
Hi all, my first post - I started teaching myself VBA two days ago, with predictable results! I want to run different macros on a single sheet depending on which cells had changes made in them. The first section of coding worked fine: Private Sub Workbook_Sheetchange(ByVal As Object,

$$Excel-Macros$$ how to use Word find and Replace to search inside a string

2013-09-29 Thread peroron2000
I am trying to figure out how to use the power of Word's Find and Replace to search inside of string variables and then replace the found sequence with something else or in some cases to remove the found item from the variable. I assumed that the following example code would work, in this case

RES: $$Excel-Macros$$ Delete Line

2013-09-29 Thread Marcio Bandeira de Azevedo - 77
Thank you very much Priti Verma!!. One more question. If I don´t want to consider the first line in the macro, because it´s not data, it´s possible? Thank you again. Marcio. De: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] Em nome de priti verma Enviada

$$Excel-Macros$$ Difference Between Function (UDF) and Macro

2013-09-29 Thread Prafull Jadhav
Dear All , Very Good Morning and Have a Great Day Ahead! I have one question ..it may is easy for you all I want to know that what is difference between Function (UDF) and Macro. When we need to create function.? and When we need to Create Macro. We can the create macro instead of UDF? Because