Vlook up Made in Hans.... (2000 sr 1)

[sal21]

Hans the line refred column F and M go in error, why?
Note: is a your old and "brilliant" suggestion about another project, remember?
I would wont to find the valu in the sheet DB and put it in F...

[sal21]

Great, but the string command tath you have posted is the same...
Peraphs?:
Range(Worksheets("DB").Range ("A2"),

[HansV]

You omitted a quote in front of A2:

Foglio5.Range("F" & cont).Value = Application.WorksheetFunction.VLookup(Range("M" & RIGA2), _
Worksheets("DB").Range(Worksheets("DB").Range(A2") , Worksheets("DB").Range("B65536").End(xlUp)), 2, False)

must be

Foglio5.Range("F" & cont).Value = Application.WorksheetFunction.VLookup(Range("M" & RIGA2), _
Worksheets("DB").Range(Worksheets("DB").Range("A2" ), Worksheets("DB").Range("B65536").End(xlUp)), 2, False)

[HansV]

Oops, yes. That was my intention. Corrected now.

[sal21]

ok, i have correct my self...
Naturally is normal for you...
You have answered mutch question in this this day...
You remain for me, NATURALLY THE BEST!!!!(See my last post to refer TROPHY MEDAL)

And Activecell.Hans(1,10) > Activecell.Sal (0,1)...;-)

Today the work is closed i have solved important problem with my family and this is the real question, by Hans.
Sal.