+ Reply to Thread
Results 1 to 2 of 2

VBA Find stopped working on Find Text (xlValue vs xlFormula)

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    VBA Find stopped working on Find Text (xlValue vs xlFormula)

    Hi,
    I have code that was working and now it has stopped working. I narrowed it down to the .Find portion. I'm looking for text "GT", which I know is there. It was working with LookIn:=xlValues and now today it will only work with LookIn:=xlFormulas. But I'm looking for text, not a formula so I would think xlValues would work (as it has in the past). So is there some setting somewhere that I messed up?

    Thank you!
    Last edited by ker9; 03-11-2014 at 09:20 AM.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: VBA Find stopped working on Find Text (xlValue vs xlFormula)

    Can we see either a copy of your code or a copy of your workbook?

+ 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. [SOLVED] Edit-Find has stopped working in the VB Editor
    By Twojay54 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2014, 02:24 AM
  2. find method stopped working after formating cells
    By kmeld in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2013, 03:49 AM
  3. Ctrl F to find text...not working
    By Oceans in forum Excel General
    Replies: 2
    Last Post: 01-18-2013, 06:55 PM
  4. Macro Stopped working: Find not Finding
    By yunesm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2011, 10:14 PM
  5. Why has the text autoprompt stopped working?
    By ddub25 in forum Excel General
    Replies: 1
    Last Post: 10-15-2009, 07: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