Results 1 to 9 of 9

Strange phenomena when use function

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    88

    Question Strange phenomena when use function

    Hi, there
    I developed a function to return a string. However, if I return the function value after the line below, it always comes out as “#Value!” in the location I am calling it. Any suggestions?


    Function FindString() as String
    Selection.Find(What:=LatNow, After:=ActiveCell, LookIn:=xlFormulas, _
    LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
    MatchCase:=False, SearchFormat:=False).Activate
    FindString="MyString"
    END Function

    Thanks in advance.

    Regards,
    Lily
    Last edited by SpringLily; 01-10-2012 at 11:16 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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