Results 1 to 14 of 14

Check if Word Exists in Array?

Threaded View

  1. #8
    Forum Contributor
    Join Date
    03-26-2015
    Location
    Cookeville, TN
    MS-Off Ver
    Excel 365
    Posts
    221

    Re: Check if Word Exists in Array?

    Here is the file. Gives runtime error 5 when it hits:
    If IsError(Application.Match(CurrentWord, BWordArray, 0)) Then
    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. HOW CHECK FILE.NAME HAS EXISTS OR NOT IN FOLDER,if not exists then copy
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2018, 03:50 AM
  2. VBA Check of string exists in an Array
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2016, 10:30 AM
  3. VBA to check if "same word" exists in a cell
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2015, 03:11 AM
  4. Check cell for word, If word exists in cell, assign that cell to corresponding category.
    By Trevasaurus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 12:35 PM
  5. Check If Value Exists In Array Help
    By mccrimmon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2011, 12:00 PM
  6. Check if word exists and count how many times, help
    By execine in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2010, 02:08 PM
  7. How to check whether a value exists in a multidimensional array variable?
    By stevenf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2009, 01:07 PM

Tags for this Thread

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