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

Answer 1 / 2
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
Answer 2 / 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