Results 1 to 8 of 8

Thread: Selection.Find, true or false?

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2003
    Posts
    406

    Resolved Selection.Find, true or false?

    I have the following code:

    Code:
    Range("B7:AA7").Select
            Selection.Find(What:=strWT, After:=ActiveCell, LookIn:=xlValues, LookAt _
                :=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
                False, SearchFormat:=False).Activate
    If the string in strWT is not found, it errors out.

    How can I test it to find out if it found the strWT or ont, so that i can pop up a message that says Can not find strWT?

    Looked for an answer on the posts, but couldn't find anything specific to the above.
    Last edited by jeffcravener; Jan 27th, 2005 at 08:36 AM. Reason: [Resolved]

Posting Permissions

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



Click Here to Expand Forum to Full Width