View original (French)

VBA Excel - save the row number

marjorykwet -  
 marjorykwet -
Hello,

I want to store the line number in a variable where the searched data is located...

Here is what I wrote...

lig = Columns(2).Find(Daterep.numerodossier1.Value, Range("B65536"))

Daterep.numerodossier1 is my variable to search for which was previously entered in a message box by the user of the program...

For now, the generated variable holds the value of my variable...

Any ideas????

Thanks in advance...
Configuration: Windows 2000 Internet Explorer 6.0

2 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    It's not true!!! You could have stayed on the same post!!!

    I forgot the property excuse me

    lig=columns(2).find(ref,range("B65536")).row

    --
    Sincerely,
    Michel
    0
  2. marjorykwet
     
    Sorry... I thought you had left...

    Now the problem is the difference formula:

    Cells(row, 14) = Cells(row, 8) - Cells(row, 7)

    It doesn't like it...
    0