+ Reply to Thread
Results 1 to 2 of 2

Define string as true. If cell contains string then cell=true problem

  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    London, UK
    MS-Off Ver
    Excel 2007
    Posts
    178

    Define string as true. If cell contains string then cell=true problem

    Hi all,

    I hope someone could help please?

    I would like to find a string in a cell. If this string is true then to perform an action.
    The string will have been found earlier on and defined to be true.

    I have the following code but it isn't working, please could someone help me? What is frustrating is that sometimes it does work and others it doesn't.

    Thanks in advance.

    Please Login or Register  to view this content.
    (Where .cells(row,1) contains the string Methodology1)

    Just to add that when I hover my mouse over my if statement it says true=true but still skips the action as if it doesn't meet the criteria.
    Last edited by Jessica.Bush; 12-27-2014 at 07:42 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Define string as true. If cell contains string then cell=true problem

    Try this,
    Please Login or Register  to view this content.

+ 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. Replies: 3
    Last Post: 09-10-2014, 04:07 PM
  2. function that returns true if it finds a string in a targeted cell
    By riwiseuse in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2013, 10:20 AM
  3. Replies: 4
    Last Post: 10-05-2013, 10:11 AM
  4. Search for a string value and make adjacent cell True
    By ChuckT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2012, 03:46 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1