Re: $$Excel-Macros$$ How to find special characters in a cell

Dear Amarender, Please try it.. Sub Special_Character() If ActiveCell.Value = Then Exit Sub End If For k = 1 To Len(ActiveCell.Value) If VBA.IsNumeric(Mid(ActiveCell.Value, k, 1)) = False And (VBA.Asc(Mid(VBA.UCase(ActiveCell.Value), k, 1)) 65 And VBA.Asc(Mid(VBA.UCase(ActiveCell.Value), k, 1)

Re: $$Excel-Macros$$ How to find special characters in a cell

Hi Noorain, It worked well, Thank you so much for your help. Best regads, Amar On 10/01/2012, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amarender, Please try it.. Sub Special_Character() If ActiveCell.Value = Then Exit Sub End If For k = 1 To Len(ActiveCell.Value) If

$$Excel-Macros$$ Special Character programme work but have to run it.

Dear Noorain, Your code is work well but I have to run it to activate. Please tell me how to run it automatically when cell value is click ? Regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

$$Excel-Macros$$ Excel macro to send mail with other than excel attachment

Dear Team In an excel sheet have data in A column Employee Name , in B Column email id of concern Employee I h ave a folder of PDF files, PDF file name are same as Employee Name and there is a PDF for all employee I want to send concern Employee his own named PDF from that folder to the email

Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

Hi Priyanka, I have a written a macro which does similar task, but I just wanted to check with you about Subject and Mail Body of the email. What would be the Subject and what should be written in the mail?? If you can give me these 2, I will modify the macro and send it to you. Regards, Anish

Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

Hi Priyanka, Check below link, hope it will help to you. http://msdn.microsoft.com/en-us/library/ee834871(v=office.11).aspx -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*

Re: Fwd: $$Excel-Macros$$ User login and logout time

Yes, after discussing with you this query is resolved. Thanks for your concern rajan. All the best !!! Regards Lokesh.M On Mon, Jan 9, 2012 at 6:55 PM, Rajan_Verma rajanverma1...@gmail.comwrote: HI Lokesh is your query resolved? ** ** Rajan. ** ** *From:*

RE: $$Excel-Macros$$ Unique count in Pivot table

HI Krishna, Output is required within Pivot table as a calculated field I think. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Jan/Tue/2012 06:45 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Unique count in Pivot

Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

Dear Noorain I have already tried this Kindly suggest if there is some other way On Tue, Jan 10, 2012 at 5:14 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Priyanka, Check below link, hope it will help to you. http://msdn.microsoft.com/en-us/library/ee834871(v=office.11).aspx --

$$Excel-Macros$$ Macro to send Email various recipients

Dear Team I need a macro which send mail from excel to the mentioned id in Excel with data E.g. : from A to D data in excel is like as below : Name |Amount| Count | Email ID i have data for 100 to 200 persons and email id of each is mentioned in front of their name I want to send mail the

Re: $$Excel-Macros$$ Unique count in Pivot table

Hi Amit find attach workbook; i have added one column in pivot data taken Sum of Unique Values in pivot i think Count of unique cabs = Sum of Unique Values check whether this helps Data WS Count of Cab # Sum of Bill amount Sum of Count of unique cabs Mahindra 6 218500 4 TATA 6

Re: $$Excel-Macros$$ Macro to send Email various recipients

Hi You can download sample workbook from below link. http://www.rondebruin.nl/sendmail.htm HTH Mahesh On Tue, Jan 10, 2012 at 6:14 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Team I need a macro which send mail from excel to the mentioned id in Excel with data E.g. : from A to D

Re: $$Excel-Macros$$ Unique count in Pivot table

Hi Amit, it's not possible to put unique value in pivot table. u need to create extra column. *Team Excel* On Sun, Jan 8, 2012 at 11:10 PM, Mahesh parab mahes...@gmail.com wrote: Hi Amit find attach workbook. hope this will help Add one column in your pivot table data use below formula

RE: $$Excel-Macros$$ How to find special characters in a cell

Hello Noorain, et.al., No need for the the VBA qualifiers. You only need to specify the VBA library name when you have another procedure with the same name in scope that would otherwise be executed instead, which is probably better avoided by not naming procedures with the names of builtins.

RE: $$Excel-Macros$$ Solution Required as per the Raw Data

Try this : See the attached file.. Data should be in same format in RawData Sheet. Revert if it not desired. Sub TranformThis() Dim rng As Range Dim rngCell As Range Dim wksRawData As Worksheet Dim wksOutput As Worksheet Dim rngTarget As Range Set

$$Excel-Macros$$ List of Dynamic named ranges in workbook

Hi Trying to get this to work. See below. Comes up with 'Invalid use of porperty' ati = i + 1 I think the probem is in the Dim declaration for i.Has Dim i As Name, at the moment, have tried others instead of 'Name' no luck. Want to list all Named Ranges (including Dynamic)

Re: $$Excel-Macros$$ How to find special characters in a cell

Okay Thanks Asa... On Tue, Jan 10, 2012 at 11:42 PM, Asa Rossoff a...@lovetour.info wrote: Hello Noorain, et.al., ** ** No need for the the VBA qualifiers. You only need to specify the VBA library name when you have another procedure with the same name in scope that

Re: $$Excel-Macros$$ List of Dynamic named ranges in workbook

Dear Cab, Please try t... Sub listnames() Dim n As Name Dim i As Long For Each n In ThisWorkbook.Names i = i + 1 Range(E i) = n.Name Next n End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/

Re: $$Excel-Macros$$ How to find special characters in a cell

Hi Asa, Noorain I'm not sure if I understood your comments. Did you meant to say we need not use the key word VBA below? Thanks, Amar On 10/01/2012, Asa Rossoff a...@lovetour.info wrote: Hello Noorain, et.al., No need for the the VBA qualifiers. You only need to specify the VBA library

$$Excel-Macros$$ how to create a user form return with vlookup query

I've a database with following headers Query ref nolocationCustomer name Query resolution Query120112-001 delhi xyz xyz abc Now i want help to create a forn in which if i entered the above query ref than all corrosponded details should return

Re: $$Excel-Macros$$ Macro to send Email various recipients

Dear Mahesh I have tried for there but there was some problem for it Kindly help for something other On Tue, Jan 10, 2012 at 11:02 PM, Mahesh parab mahes...@gmail.com wrote: Hi You can download sample workbook from below link. http://www.rondebruin.nl/sendmail.htm HTH Mahesh On Tue,

Re: $$Excel-Macros$$ List of Dynamic named ranges in workbook

Hi Noorain Works good now. Thanks. How do I get it to show also the range of cells in each name. e.g. List ASheet1 B.7:H50 Thanks Charlie On Wed, Jan 11, 2012 at 4:20 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Cab, Please try t... Sub listnames() Dim n As Name

RE: $$Excel-Macros$$ How to find special characters in a cell

Hi Amar, Correct. Noorain's code should work just as well if you eliminate all instances of VBA. from it. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kasireddy Amarender Sent: Tuesday, January 10, 2012 7:55 PM To: