Re: $$Excel-Macros$$ Macro for outlook

Hello Rajan Could you please inform how to use this code in outlook. Thanks Pravin Gunjal. On Mon, Sep 17, 2012 at 7:58 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *I have created below macro before sometime you can use this and can add more words condition in Red Line* * * *Option

$$Excel-Macros$$ Re: Sort Hidden and Unhidden Rows

Hi Dik, just use sub SortData(rngData, as range,intCol as integer) end sub On Tuesday, September 18, 2012 3:31:47 AM UTC+5:30, Dick wrote: Heed help is sorting hidden rows. Is there a vb macro code that someone can help me with to sort reguardless if the rows are hidden or not.Thanks

$$Excel-Macros$$ Re: Sort Hidden and Unhidden Rows

please ignore my last post. And Please Modify this Method according to ur requirment Sub test() Dim rng As Range Dim varArr As Variant Dim intPrev As Integer Dim intNext As Integer Dim intTempAs Integer With

Re: $$Excel-Macros$$ Re: Check for Repeats in cell

Hi Here formula used is *=NOT(ISERROR(FIND($A$1,Formula,1))) *where in you have used function *formula *but i am not able to view code in sheet? So formula is inbuilt function then? Rgds Vabs On Mon, Sep 17, 2012 at 7:55 PM, Vabz v...@vabs.in wrote: Dear Rajan, Yes definitely it works..

$$Excel-Macros$$ hello

this is interesting http://www.newsisto.net/jobs/?article=18116 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ Macro for outlook

Thanks Rajan.! Per my understanding, I need to add first OR then need to use code. Ex: *If InStr(strText, Attach) Or InStr(strText, PFA) Or **InStr(strText, Included) **Then* Please check line for included word. # Rajan, Mails/discussion not getting received on my Gmail but I can able to

Re: $$Excel-Macros$$ hello

Sorry guys but someone used my nick and send it throught   Can admin look at it, please.   Real :)   Pawel From: pawel lupinski lupins...@yahoo.com To: clai...@rhl.co.uk Sent: Tuesday, September 18, 2012 9:21 AM Subject: $$Excel-Macros$$ hello this is

RE: $$Excel-Macros$$ Re: Check for Repeats in cell

Formula Is name range.. which get ActiveCell Formula through Get.Cell(41,CellAddress) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of VBA VABZ Sent: 18 September 2012 1:18 To:

Re: $$Excel-Macros$$ Spreadsheet within Spreadsheet

Thank you very much! Christoph On Monday, September 17, 2012 11:10:35 AM UTC-4, Rajan_Verma wrote: *Yes.. it will work for 2010 also, even I have created this in 2010 **J** * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-...@googlegroups.com

$$Excel-Macros$$ Sum base on condition in another column

Hi All, I need your help regarding to this: what I want is to sum up column D base on condition in column N. Regards, Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ Sum base on condition in another column

SUM(SUMIF(C:C,F3:F5,D:D)) press ctrl_+shft +enter On Tue, Sep 18, 2012 at 9:42 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All,** I need your help regarding to this: what I want is to sum up column D base on condition in column N. Regards, Pawel -- Join official

$$Excel-Macros$$ Senior Test lead / manager / Chicago / 12 months

Hi, Hope you are doing great ! Title - Senior Test lead Location - Chicago Duration -12 months Compensation - Best in the industry Primary skill Candidate should have strong Test Management skills, have atleast 8 years of Testing background. Experience in Financial Domain is a plus

Re: $$Excel-Macros$$ UNIX/Java Dev for WI

Job posting is not allow on this forum. please follow forum rule. Sent from BlackBerry® on Airtel -Original Message- From: sancrosoft suma1 sancrosoftsu...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 18 Sep 2012 10:56:58 Reply-To: excel-macros@googlegroups.com Subject:

$$Excel-Macros$$ Reverse of FREQUENCY

Hi there, Experts, I use the FREQUENCY command a lot to group data into buckets via an array. It works great. I was wondering if there is a reverse function for this. In other words a lookup that allows to use buckets. Say in column A1 I have the minimum value of a bucket, in this example

Re: $$Excel-Macros$$ Sum base on condition in another column

thanks a lot, it was briliant.   pawel From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, September 18, 2012 5:16 PM Subject: Re: $$Excel-Macros$$ Sum base on condition in another column SUM(SUMIF(C:C,F3:F5,D:D)) press

Re: $$Excel-Macros$$ Download a web page that is only accessible through javascript

Sim. :) On Monday, September 17, 2012 3:41:29 PM UTC-4, Tanato C. wrote: Olá Gafanhoto estais no Brasil? 2012/9/17 Gafanhoto andre...@gmail.com javascript: Hello friends, I'm using Excel 2010 on Windows 7 and I'm trying to find a code that autamatically downloads the page that, for

Re: $$Excel-Macros$$ Senior Test lead / manager / Chicago / 12 months

Job posting is not allow on this forum Sent from BlackBerry® on Airtel -Original Message- From: Himanshu Sharma himan...@diverselynx.com Sender: excel-macros@googlegroups.com Date: Tue, 18 Sep 2012 16:34:19 To: himanshudiversel...@gmail.comhimanshudiversel...@gmail.com Reply-To:

RE: $$Excel-Macros$$ How to put sum formula automatically - seems easy but not so

Thanks Swapnil, This is exactly what I was looking for.. You not saved my day but a lot of days.. Regards, Jaideep Panchal From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Swapnil Palande Sent: Friday, September 14, 2012

RE: $$Excel-Macros$$ How to put sum formula automatically - seems easy but not so

Hi Rajan, This is exactly what I was looking for and it will save atleast 2 days in a month... Regards, Jaideep From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Friday, September 14, 2012 9:57 PM To:

RE: $$Excel-Macros$$ How to put sum formula automatically - seems easy but not so

Dear, Rajan and Swapnil provided me the solution for the mentioned problem. it is solved now.. However, your method gave me a hint to solve another issue for me.. Thanks a lot for quick response... Thanks, Jaideep From: excel-macros@googlegroups.com

$$Excel-Macros$$ Best wishes of festival : Ganesh Chathurthi

Hi All Champs, I wish you all happy blessed Ganesh Chathurthi.. http://mylordganesha.files.wordpress.com/2011/09/lalbaugcha-raja-20111.jpg Stay blessed Keep Rocking alwayz.. Cheerz.. Rgds//Vabs -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

$$Excel-Macros$$ subtitute function infirmation required

Dear Expert, i want know about subtitute. anybody tell me about subtitute function.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ subtitute function infirmation required

Hi, Please read below hope it will help you to understand substitute function.. In Excel, the *SUBSTITUTE* function replaces a set of characters with another. The syntax for the *SUBSTITUTE* function is: SUBSTITUTE( text, old_text, new_text, [nth_appearance] ) *text* is the original string

Re: $$Excel-Macros$$ subtitute function infirmation required

Hi see below links: http://office.microsoft.com/en-us/excel-help/substitute-function-HP010062578.aspx http://www.techonthenet.com/excel/formulas/substitute.php Regards, Kuldeep Singh On Wed, Sep 19, 2012 at 11:17 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, i want know

Re: $$Excel-Macros$$ subtitute function infirmation required

Please find below : http://blog.contextures.com/archives/2011/01/28/30-excel-functions-in-30-days-27-substitute/ Karan Singh On Wed, Sep 19, 2012 at 11:23 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi see below links: