VBA Vlookup

J

Jeff

Hello,

I need a VBA formula that would execute a Vlookup between 2 workbooks.
However, the range for the Vlookup starts from a row that has a text, but
never has the same row number. In other word: it is possible to have a
Vlookup with a range starting from a referenced row that moves all the time ?
Jeff
 
S

SeaparkJohn

Give the referenced row a name through Insert>Name. Now, in the code refer
to the row through it's name and Excel will dynamically locate it.
 
Top