Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    find method...two parameter (2000)

    I use this code to find in column if is prersent a value, but the code work only if i use ONE column in this case is O.
    Now admit i have

    SERV to find in O
    and
    SRRV1 to find in L

    how to?
    Naturally use the find on same line in sheet


    Set found_index = WS.Columns("O:O").Find(SERV, LookIn:=xlFormulas)
    If Not found_index Is Nothing Then
    RIGA1 = found_index.Row
    WS.Range("P" & RIGA1) = WS.Range("P" & RIGA1).Value + 1
    End If

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: find method...two parameter (2000)

    I'm sure you have asked something like this before (here and probably also in other forums), so do a search for your older posts.

Posting Permissions

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