$$Excel-Macros$$ delete row only the next mob no same

2010-01-21 Thread manoj kumar
Hi Sir I have a list of several thousands email in it but there are so many emails same I have sorted the list but cannot delete all the files which are copied of the above row please help -- -- Some important lin

$$Excel-Macros$$ Delete rows only if the entire row is empty

2010-01-21 Thread Vinod N
Dear Gurus, Macro or any other way in excel where the user should be able to delete rows only if the entire row is empty... Please help... -- Thanks and Regards Vinod N -- -- Some important links for excel users:

RE: $$Excel-Macros$$ Workbook.Selection Change Event

2010-01-21 Thread Dave Bonallack
Oops and: If Activeworksheet.Name = "Main" Then From: davebonall...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Workbook.Selection Change Event Date: Fri, 22 Jan 2010 12:52:44 +0800 Hi, Try: Private Sub Workbook_SheetActivate(ByVal Sh As Object) Dave. Dat

RE: $$Excel-Macros$$ Workbook.Selection Change Event

2010-01-21 Thread Dave Bonallack
Hi, Try: Private Sub Workbook_SheetActivate(ByVal Sh As Object) Dave. Date: Thu, 21 Jan 2010 23:18:50 +0530 Subject: $$Excel-Macros$$ Workbook.Selection Change Event From: harpreetguj...@gmail.com To: excel-macros@googlegroups.com Hi, Need help regarding the following code: I have written

RE: $$Excel-Macros$$ Exporting data using Pulldown List

2010-01-21 Thread Sandip Patel
Hi Ankur, Really appreciate your help. It is working as I wanted. But When I change the symbol in column A, it is giving an error. Please see the attached file. Is it possible that it allows me to enter the symbol in any sequence, as long I have all the required values of that particular symbol

$$Excel-Macros$$ If Conditions - Urgent Help Required

2010-01-21 Thread Abhishek Jain
* URGENT* Hi friends, Please help me on this: CategoryType of Cargo Time taken A+ Cartons 1 hour A+ Bales 1.5 hours A+ Pall

Re: $$Excel-Macros$$ Sum Based on date criteria

2010-01-21 Thread Ahmedhonest
Dear Mahesh, You if you are familiar with SumIfs formula you can make use of this, else make use of help in the excel to understand how sumifs can be effectively used. I hope this SUMIFS will solve your query Regards Ahmed Bawazir On Wed, Jan 20, 2010 at 8:29 AM, mahesh parab wrote: > Dear Al

$$Excel-Macros$$ Workbook.Selection Change Event

2010-01-21 Thread Harpreet Singh Gujral
Hi, Need help regarding the following code: I have written a code which would help me to determine Which sheet is the user on, and if that matches the criteria, then the statement would be executed. I believe, that i am not able to make the macro identify which sheet is the User on. Code: Priva

RE: $$Excel-Macros$$ How do i

2010-01-21 Thread Dave Bonallack
Hi Paddy, Try this: Sub MyFormula() ActiveCell = "=Your Formula goes here" End Sub Regards - Dave > Date: Thu, 21 Jan 2010 01:27:19 -0800 > Subject: $$Excel-Macros$$ How do i > From: ryan0...@gmail.com > To: excel-macros@googlegroups.com > > create a macro that means i can select any

$$Excel-Macros$$ add-in manager

2010-01-21 Thread Frédéric
Hello, I use Excel 2003 and I would like to know why Add-in manager in "Visual Basic Editor" is not available when I'm not administrator. regards -- -- Some important links for excel users: 1. Follow us on TWITTER fo

$$Excel-Macros$$ Macro not exporting cell data as is, its rounding up...

2010-01-21 Thread Gary
Hey all, I've downloaded a Macro http://meadinkent.co.uk/ and have been editing it get the exported XML to appear as required, however I can't seem to get the 2 of my fields to display correctly. There are two fields which have numbers in but are formatted as text because I do not want them rounde

Re: $$Excel-Macros$$ Help Required - Gantt Chart

2010-01-21 Thread ganesh gw
hi, check this file i created it will help U. pl give me feedback on this On 1/20/10, Rakesh Sharma <> wrote: > > Hi Maniyan, > > Here is the solution which I think my help you. > > > > Regards > Rakesh > > -- > The INTERNET now has a personality. YOURS! See your Ya

Re: $$Excel-Macros$$ Excel can Speak now

2010-01-21 Thread Dhananjay Pinjan
Please send me the Excel File Thanks & Regards, Dhananjay On Thu, Dec 31, 2009 at 12:41 AM, Vishal Parihar wrote: > Hi Friends > > The below code are to use:- > > Application.Speech.Speak ("vishal parihar") > > Regards > Vishal Parihar > > I hope you will like it. > > -- > > ---

$$Excel-Macros$$ How to determine if a chart is embedded or not

2010-01-21 Thread deltaquattro
Hi guys, a question for you Excel VBA experts. I wrote the following function which applies formatting to a chart: Function FormatAxes(Optional SheetName As String, Optional ChartName As String, _ Optional IsEmbedded As Boolean, _ Optional Xmin, Optional Xmax, Optional Ymin, Optional Ymax, Option

$$Excel-Macros$$ Re: How to convert file PDF to Excel

2010-01-21 Thread Anil
Hi Rajani, check this link: http://www.pdftoexcelonline.com/ Regards, Anil On Jan 21, 10:49 am, rajani chintan wrote: > Sir > how to convert PDF to Excel ? -- -- Some important links for excel users: 1. Follow us o

$$Excel-Macros$$ Re: How to convert file PDF to Excel

2010-01-21 Thread Anil
Hi Rajani, check this Link: www.pdftoexcelonline.com/ Regards, Anil On Jan 21, 10:49 am, rajani chintan wrote: > Sir > how to convert PDF to Excel ? -- -- Some important links for excel users: 1. Follow us on TWITT

$$Excel-Macros$$ How do i

2010-01-21 Thread Paddy
create a macro that means i can select any cell and when i execute the macro the formula will appear in the cell selected rather than the cell where it was created. Thanks Paddy -- -- Some important links for excel

$$Excel-Macros$$ Re: How to convert file PDF to Excel

2010-01-21 Thread Anil
Hi Rajani, check this Link: www.pdftoexcelonline.com/ Regards, Anil pdf to excel converter On Jan 21, 10:49 am, rajani chintan wrote: > Sir > how to convert PDF to Excel ? -- -- Some important links for excel user

$$Excel-Macros$$ Re: How to convert file PDF to Excel

2010-01-21 Thread Anil
Hi Rajani, check this link : http://www.pdftoexcelonline.com/ there are few more converters available online. Search in Google by using Key word : pdf to excel converter Regards, Anil On Jan 21, 10:49 am, rajani chintan wrote: > Sir > how to convert PDF to Excel ? -- -

Re: $$Excel-Macros$$ How to convert file PDF to Excel

2010-01-21 Thread ankur
hi rajani there are so many software and sites, which can convert pdf files into word or excel plz attach file, i will convert it for you On 21/01/2010, rajani chintan wrote: > Sir > how to convert PDF to Excel ? > -- Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Differen

Re: $$Excel-Macros$$ Sum Based on date criteria

2010-01-21 Thread kvc praveen kumar
You are welcome Mahesh!! Have a nice day!! Regards, Praveen On Thu, Jan 21, 2010 at 9:03 AM, mahesh parab wrote: > Hi Praveen,Ankur,Dave > > thank you all of you ! > > > On 1/20/10, Dave Bonallack wrote: > >> Hi, >> Have a look at the attached. Let me know if it's what you need. >> Regards -