Results 1 to 10 of 10

Vowel hook search

Threaded View

  1. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Vowel hook search

    In case I got it right you need to find all matches that contains letters.
    Try this one.
    Sub Button1_Click()
    Dim wrdCount As Long
    Dim arr
    Dim i, j As Long
    
    wrdCount = ActiveSheet.Cells(ActiveSheet.Rows.Count, "A").End(xlUp).Row
    arr = Range("B1:B" & wrdCount)
    j = 2
    For i = 1 To wrdCount
        If InStr(1, arr(i, 1), Range("F2").Text, vbTextCompare) > 0 And InStr(1, arr(i, 1), Range("G2").Text, vbTextCompare) > 0 And InStr(1, arr(i, 1), Range("H2").Text, vbTextCompare) > 0 And InStr(1, arr(i, 1), Range("I2").Text, vbTextCompare) > 0 Then
            Range("K" & j).Value = arr(i, 1)
            j = j + 1
        End If
    Next
    
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] First Vowel
    By MRozell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-06-2016, 08:15 AM
  2. [SOLVED] Vowel extracting in alpha order
    By makinmomb in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-18-2016, 09:18 AM
  3. Macro to search a string ending with vowel "AEIOUY"
    By kitunga in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-02-2014, 02:37 PM
  4. Hook into Yahoo Site Exploer API?
    By gnome_core in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2009, 03:28 PM
  5. Getting a hook on Toolbar Events
    By WhytheQ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2006, 07:40 AM
  6. [SOLVED] hook into worksheet events temporarily?
    By Alex Popescu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2005, 09:30 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