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

    Intercept the real number of line... (2000 sr -1)

    I have this code to find in column if existis a value...
    But how to intecept the real number of line where is the value founded?
    sheet attached...
    'CONTROLLO DATE
    INDEX_DATE = FOGLIO & "-" & DATAIN & "-" & DATAFIN
    ID = INDEX_DATE
    Set Found_ID = Sheets("STATISTICA").Columns("N:N").Find(ID, lookat:=xlWhole)
    If Found_ID Is Nothing Then
    'RIGA = Found_ID.RNG
    MsgBox ("EMAIL GIA' INVIATE PER QUESTO PERIODO"), vbInformation
    GoTo FINE
    End If
    'CONTROLLO DATE

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

    Re: Intercept the real number of line... (2000 sr -1)

    Riga = Found_ID.Row

    This will only work if Found_ID is *not* Nothing.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intercept the real number of line... (2000 sr -1)

    Hummm, and to find wath i use "Not Nothing"?

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

    Re: Intercept the real number of line... (2000 sr -1)

    Sorry, what do you mean?

Posting Permissions

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