Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Search on Text Challenge (XL97; SR2)

    I have an issue with searching on a column of data. It seems that if the cells in a column that is being searched has a formula in it, nothing is being returned. If some of the cells in the column contain text and formulas then only the text is returned. How does one get the value of the cell or cells returned.

    I have attached the XL file that I'm having the issue with.

    Thanks,
    John
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search on Text Challenge (XL97; SR2)

    You need to choose Values from the dropdown list in the "Look in: " box in the Find box.

    Why MS make Formulas the default in this box is beyond me, I hardly ever use this setting.

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Search on Text Challenge (XL97; SR2)

    Hi John,

    If you change the statement:
    Set oCell = .Find(What:="*" & PromptTab & "*")
    to
    Set oCell = .Find(LookIn:=xlValues, What:="*" & PromptTab & "*")
    that should work.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search on Text Challenge (XL97; SR2)

    Thank you...it works.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •