Results 1 to 6 of 6

for loop with an instring

Threaded View

  1. 08-15-2013, 04:25 PM #1
    bruinsrme
    bruinsrme is offline
    Registered User
    Join Date
    04-15-2013
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    26

    Thumbs up for loop with an instring

    Hello,

    I have to loop through column and if column A starts with OJT then change Item type to OJT, else do nothing and continue.

    Any help on this would be so appreciated.

    A B
    Item ID Item Type
    GI-WRS-CBT Course
    IATA123 Course
    OJT-014-33 SOP
    OJT-014-26 SOP
    OJT-014-39 SOP
    OJT-014-35 SOP
    OJT-014-35 SOP
    OJT-014-35 SOP
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)
    By nixon72 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2013, 12:46 PM
  2. Why did an inner loop variable start overwriting the outer loop range suddenly?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2012, 03:24 PM
  3. Search & Replace InString
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-03-2010, 05:25 PM
  4. Include/Exclude Specific Instring Characters From A Querry Search
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-05-2010, 03:43 PM
  5. Help with instring code
    By Elaine in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-20-2005, 11:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1