+ Reply to Thread
Results 1 to 2 of 2

"Find" doesn't work when cell has formula in it

  1. #1
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    "Find" doesn't work when cell has formula in it

    I'm trying to get this to work, but it doesn't pickup "Orange" because a formula in the cell concatenates the word.


    HTML Code: 
    Sub Macro1()
        Dim col2_num As Integer
        col2_num = Sheets("Sheet1").Rows("5:5").Find("Orange").Column
        MsgBox col2_num
    End Sub
    Attached Files Attached Files
    Last edited by Xx7; 02-01-2014 at 10:44 PM.

  2. #2
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: "Find" doesn't work when cell has formula in it

    I believe I was missing --> LookIn:=xlValues

    HTML Code: 
    Sub Macro1()
        Dim col2_num As Integer
        col2_num = Sheets("Sheet1").Rows("5:5").Find(What:="Orange", _
        LookIn:=xlValues).Column
        MsgBox col2_num
        
    End Sub

+ 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. Open files from FTP server (works with "servername" but doesn't work with "ip address")
    By adammsu1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2012, 04:30 PM
  2. "Move and Size with Cell" sometimes doesn't work with VBA created Buttons
    By daveNYC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2012, 03:27 PM
  3. "find" menu doesn't work
    By mahmoodn in forum Excel General
    Replies: 2
    Last Post: 02-24-2012, 07:49 AM
  4. vba doesn't work with "iferror()" and formula autofill problem
    By lkim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2012, 07:47 AM
  5. [SOLVED] Find formatting doesn't work: "Excel cannot find data"
    By Kasama in forum Excel General
    Replies: 1
    Last Post: 08-18-2006, 08:45 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