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: excel-

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 wrote: > Dear Cab, > > Please try t... > > Sub listnames() > Dim n As Name > Dim i As Long > > Fo

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 wrote: > Hi > > You can download sample workbook from below link. > > http://www.rondebruin.nl/sendmail.htm > > > HTH > Mahesh > > On Tue, Jan 10,

$$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 either

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 wrote: > Hello Noorain, et.al., > > > > No need for the the VBA qualifiers. You only need to specify the VBA > library name when y

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://noorain-ansar

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 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 would otherwise

$$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) in

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 wksOutpu

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$$ 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 wrote: > Hi Amit > > find attach workbook. hope this will help > Add one column in your pivot table data & use below formula > Assuming you w

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 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 data in excel is li

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 255

$$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 data

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

Subject and body will be simple e.g. Sub : Data for the month Jan-12 and Email Body : Dear Sir/Mam Kindly find the attached file On Tue, Jan 10, 2012 at 4:08 PM, Anish Shrivastava wrote: > Hi Priyanka, > > I have a written a macro which does similar task, but I just wanted to > check with you

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 wrote: > 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,

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 t

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 wrote: > HI Lokesh > > is your query resolved? > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com

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://noorain-ansari.blogspot.com/*

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, Ani

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

Dear Ashish, Call the procedure under..Selection Change Event For Particular Sheet.. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Call Special_Character 'Procedure name End Sub For workbook.. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Cal

$$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 em

$$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 Pleas

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 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 VBA.IsNumeric(Mid(A

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,