Re: $$Excel-Macros$$

Sub test() Application.DisplayAlerts = False Dim i As Long, s As Long Sheets(1).Select For i = 3 To Range("c65356").End(xlUp).Row s = Application.WorksheetFunction.CountIf(Range("c:c"), Range("c" & i)) - 1 Call merge_rng(Range("c" & i & ":c" & i + s)) i = i + s Next For i = 3 To Rang

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

Congratulation!! Keep up the gud work. On Fri, Feb 1, 2013 at 11:31 PM, Sam Mathai Chacko wrote: > Excellent work again Prince. Keep up the great work. > > > On Sat, Feb 2, 2013 at 12:29 PM, wrote: > >> ** >> Bravo again ♍Ɣ friend well done and thanks for your massive and valuable >> support.

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

Excellent work again Prince. Keep up the great work. On Sat, Feb 2, 2013 at 12:29 PM, wrote: > ** > Bravo again ♍Ɣ friend well done and thanks for your massive and valuable > support. > Sent from my BlackBerry® smartphone from Airtel Ghana > -- > *From: * Ayush Jain

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

Bravo again ♍Ɣ friend well done and thanks for your massive and valuable support. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Sat, 2 Feb 2013 11:49:07 To: excel-macros Reply-To: excel-macros@googl

$$Excel-Macros$$ undo macro

Hi All, I've macro like: Private Sub Worksheet_SelectionChange(ByVal Target As Range)     If Not Intersect(Target, Range("B23:HH400")) Is Nothing Then     ActiveWorkbook.Names("ActiveRow").RefersTo = "=" & ActiveCell.Row     End If End Sub unfortunately I can't undo any changes. Is the anyway

Re: $$Excel-Macros$$ Macro to Insert Rows Based on a Cell Value and put in the Value against each row.

Thanks Ashish. Works like charm, As always you all are a great help. On Thursday, January 31, 2013 8:56:30 PM UTC+4, ashish wrote: > *Try this code* > > Sub SJ() > Application.DisplayAlerts = False > Dim i As Long, j As Long > > On Error Resume Next > Sheets("Output").Delete

Re: $$Excel-Macros$$ Getting Email Pattern

ashish , can you explain On Fri, Feb 1, 2013 at 10:27 AM, wrote: > ** > Use > > Fn first name > Fni or fi first intial > Ln last name > Lni or li last name intial > Sent on my BlackBerry® from Vodafone > -- > *From: * rajan verma > *Sender: * excel-macros@googlegroup

$$Excel-Macros$$ Re: Macro - To split each spreadsheets as a new workbook

Hi Santhosh, Please find attached workbook and let me know if it works. Thanks and regards, Shekhar On Friday, 1 February 2013 23:14:56 UTC+5:30, mks...@gmail.com wrote: > > Hi Friends, > > Need a macros to split each spreadsheet into a different workbook and save > as the tab name. > > Fo

Re: $$Excel-Macros$$ Macro - To split each spreadsheets as a new workbook

Thanks a lot ... Vijay On Fri, Feb 1, 2013 at 11:30 PM, vijayajith VA wrote: > Hi Sandhosh. > > Sub Splitsht() > > ChDir "C:\Documents and Settings\user\Desktop\folder" > > Dim wrksht As Worksheet > > For Each wrksht In ThisWorkbook.Worksheets > wrksht.Select > wrksht.Copy > A

Re: $$Excel-Macros$$ Macro - To split each spreadsheets as a new workbook

Have you done any VBA on your own? This is simply a matter of recording a macro in which you perform the steps for one sheet. Then, wrap a "loop" around the code, substituting a variable for the sheet and file names. it can be done fairly quickly... let us know what part you need help with.   P

Re: $$Excel-Macros$$ Macro - To split each spreadsheets as a new workbook

Hi Sandhosh. Sub Splitsht() ChDir "C:\Documents and Settings\user\Desktop\folder" Dim wrksht As Worksheet For Each wrksht In ThisWorkbook.Worksheets wrksht.Select wrksht.Copy ActiveWorkbook.SaveAs Filename:=wrksht.Name & ".xlsx" ActiveWindow.Close Next End Sub Thanks

$$Excel-Macros$$ Macro - To split each spreadsheets as a new workbook

Hi Friends, Need a macros to split each spreadsheet into a different workbook and save as the tab name. For Example : Split "Apple" tab only from current workbook and save it as new workbook , file name should be tab name . Please find atatchment. Regards, Santhosh -- Join official Facebook

Re: $$Excel-Macros$$ Getting Email Pattern

Use Fn first name Fni or fi first intial Ln last name Lni or li last name intial Sent on my BlackBerry® from Vodafone -Original Message- From: rajan verma Sender: excel-macros@googlegroups.com Date: Fri, 1 Feb 2013 09:59:08 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-M

$$Excel-Macros$$ Getting Email Pattern

I am wondering if someone can suggest a smart solution to identify the pattern of email id. Name ID pattern Ravi verma ravi.ve...@gmail.com fff@gmail.com Ravi verma rve...@gmail.com f...@gmail.com Ravi verma r.ve...@gmail..com f@gmail.com Ravi verma rav...@gmail.com ff...@gmail.com

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

Any solution friends. Sent on my BlackBerry® from Vodafone -Original Message- From: joseph camill Sender: excel-macros@googlegroups.com Date: Fri, 1 Feb 2013 09:56:08 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Database sort (copy

Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

Dear Anil, Thank you again for your efforts. It seems however that as I run the program, that in cases where there is less that 5 within a category, the transpose then erroneously pastes the figures. For example, if I were to move the last data set of 1,2,5 to the first and move all else belo

Re: $$Excel-Macros$$ convert Excel into pdf

From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Fri, February 1, 2013 10:24:44 AM Subject: Re: $$Excel-Macros$$ convert Excel into pdf I've used this since Office97/2003. (It is currently functioning in Excel2010)     ActiveWorkbook.ExportAsFi

$$Excel-Macros$$ Re: Forum rules : Please adhere else you will be BANNED

Dear Ayush, I have to click on this link every time to access group, I'm still confused that i haven't become member of this group On Saturday, July 23, 2011 5:50:06 PM UTC+5:30, Ayush Jain wrote: > > Hello everyone, > > Please adhere to below rules of the forum. You will be banned without >

Re: $$Excel-Macros$$ convert Excel into pdf

I've used this since Office97/2003     ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, _     filename:="enter_path_and_file_name_here", _     Quality:=xlQualityStandard, _     IncludeDocProperties:=True, _     IgnorePrintAreas:=False, OpenAfterPublish:=Fals

Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

Dear Anil, Please accept my apologies. I had made an error on my part in accidentally having deleted a letter from the file you provided. As a matter of fact, your solution works great. Thank you very much for all of your efforts on this. I sincerely appreciate it. Best regards and wishing you

Re: $$Excel-Macros$$ Re: How to order data in rows into distinct column sets

Dear Anil, Thank you for your file and effort. Every time I run the file, it gives me the following error: Compile Error: Invalid outside procedure. Do you have advice on how I may fix this so I may test? Thank you again. Alpesh On Thursday, January 31, 2013 11:33:36 PM UTC-5, अनिल नारायण गवली

Re: $$Excel-Macros$$ Need formula

Dear Kailash, Send your request on below email ID. macros+unsubscr...@googlegroups.com . On Fri, Feb 1, 2013 at 3:45 PM, Mishra, Kailash (GE Capital, Non-GE) < kailash.mis...@ge.com> wrote: > Hi > > ** ** > > Please remove my id from the group …… > > ** ** > > Regards > > ** **

Re: $$Excel-Macros$$ Formula to find items between two dates *

Thanks Experts, i have aadjusted my formula, its working now. thanks On Fri, Feb 1, 2013 at 11:36 AM, Hilary Lomotey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup > rule

$$Excel-Macros$$ Formula to find items between two dates

Hello Experts i have some general data in sheet one, i want to enter a start date and an end date in sheet two so that items within these dates should pop up, my formulas are not working , kindly assist. thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

$$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.

Sir,    I have data of Station and category in columns a and b.  But  I want the report in category wise as in columns h to k.  When i use the sumproduct formula it works and it is not working in vba. Please guide how to modify the vba to get the desired result.(formula used is available in the

RE: $$Excel-Macros$$ Need formula

Hi Please remove my id from the group .. Regards Kailash From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of >>Excel Beginner<< Sent: Friday, January 18, 2013 12:00 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need form

Re: $$Excel-Macros$$ Successfully passed the microsoft digital certification course.

Good Work and thanks a lot anil for sharing this gr8 info but plz be sure to share any such future opportunity Thanks once again On Fri, Feb 1, 2013 at 2:03 PM, अनिल नारायण गवली wrote: > its free of cost and take half an hour to complete > go to http://dsaksharta.in/ > register and go.. >

RE: $$Excel-Macros$$ Successfully passed the microsoft digital certification course.

Okay thanks. Best Regards, Amit Desai +91 98672 32534 From: अनिल नारायण गवली [mailto:gawlianil8...@gmail.com] Sent: 01 February 2013 14:03 To: excel-macros@googlegroups.com; Amit Desai (MERU) Subject: Re: $$Excel-Macros$$ Successfully passed the microsoft digital certification course. its free

Re: $$Excel-Macros$$ Successfully passed the microsoft digital certification course.

its free of cost and take half an hour to complete go to http://dsaksharta.in/ register and go.. Warm Regards, Gawli Anil On Fri, Feb 1, 2013 at 1:24 PM, Amit Desai (MERU) wrote: > Please provide more details of the certification; > > ** ** > > **1) **From where did you gave exam;

Fwd: Re: Fwd: Re: $$Excel-Macros$$ Macro to create Template and apply protection

Hi boss The challlenge is that users can work in the template cos all the cells are locked could u kindly have only the formulas locked so the non formula cells can be edited tried lockin all formulas only from the main template but that didnt wk thanks -- Forwarded message --