+ Reply to Thread
Results 1 to 2 of 2

VB Code to find 1st Occurrence of text in column A

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to find 1st Occurrence of text in column A

    Hello:

    I have lots of duplicate text strings in column A.
    I need a VB Code to find the location of 1st occurrence of say text "Totals".

    I need to use this in my existing code:

    Please Login or Register  to view this content.
    Remember that i have 2nd occurrence of text "Totals" which i will use futher in the same macro.

    Please help and let me know if any questions.

    Thank you in advance.

    Riz Momin
    Last edited by rizmomin; 12-25-2013 at 09:23 AM.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: VB Code to find 1st Occurrence of text in column A


    Hi,

    easy with the Find method or the worksheet function Match

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Code to Find Specified text within a Column and perform Text to Column
    By MHamid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2014, 06:42 AM
  2. Replies: 4
    Last Post: 07-01-2012, 07:24 PM
  3. Replies: 0
    Last Post: 07-29-2011, 08:44 AM
  4. code to find text, offset 1 column and paste to new workbook not working
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-10-2011, 07:55 AM
  5. Replies: 3
    Last Post: 03-24-2011, 02:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1