+ Reply to Thread
Results 1 to 14 of 14

Check if Word Exists in Array?

Hybrid View

Merf Check if Word Exists in Array? 01-14-2022, 04:11 PM
JEC. Re: Check if Word Exists in... 01-14-2022, 04:13 PM
Fluff13 Re: Check if Word Exists in... 01-14-2022, 04:19 PM
JEC. Re: Check if Word Exists in... 01-14-2022, 04:20 PM
Merf Re: Check if Word Exists in... 01-14-2022, 04:39 PM
Fluff13 Re: Check if Word Exists in... 01-14-2022, 04:48 PM
JEC. Re: Check if Word Exists in... 01-14-2022, 04:50 PM
Merf Re: Check if Word Exists in... 01-14-2022, 05:07 PM
Merf Re: Check if Word Exists in... 01-14-2022, 05:11 PM
AB33 Re: Check if Word Exists in... 01-14-2022, 05:15 PM
Merf Re: Check if Word Exists in... 01-14-2022, 05:20 PM
jolivanes Re: Check if Word Exists in... 01-14-2022, 05:17 PM
jolivanes Re: Check if Word Exists in... 01-14-2022, 05:19 PM
JEC. Re: Check if Word Exists in... 01-14-2022, 05:25 PM
  1. #1
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Check if Word Exists in Array?

    There is no AWordArray but WordArray has been erased by Erase AWordArray
    Last edited by AB33; 01-14-2022 at 06:03 PM.

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

    Re: Check if Word Exists in Array?

    Quote Originally Posted by AB33 View Post
    There is no WordArray but WordArray has been erased by Erase AWordArray
    Ah, of course!!
    Forgot that Erase doesn't merely clear a dynamic array. I guess I should Redim each time rather than Erase!
    THANKS for locating my screw-up!

+ 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. 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