VBA Insert Name and Vlookup

[daily106]

Hello Guys,

I would like to know what is the problem with the below code. Basically, I am doing a vlookup on V2 by looking up the value of D4 from inserted name("salesManagers"). I hope to do Autofilldown for V column and copy/paste special value.




Sub Test()

Dim iiii as Long

'Insert Range Names
Sheets("Vendorlist").Range("A:B").CurrentRegion.Name = "SalesManagers"

'vlookup

For iiii = 2 To Range("A65536").End(xlUp).Row

Range("V2") = Application.VLookup(Cell(iiii, 4), Range("SalesManagers"), 2, 0)

Next iiii

End Sub

 

[daniels012]

Range("V2") = Application.VLookup(Cell(iiii, 4), Range("SalesManagers"), 2, 0)

I am not the best at VBA by any stretch of the imagination but try:

Range("V2") = WorksheetFunction.VLookup(Cell(iiii, 4), Range("SalesManagers"), 2, 0)

 

[Norie]

There is no such thing as Cell.

Try Cells.

 Range("V2") = Application.VLookup(Cells(iiii, 4), Range("SalesManagers"), 2, 0)

By the way why not just put the VLOOKUP formula in the cells?

 

[daniels012]

See Norie is Awesome!
I am just an amateur in this realm of pros!!!!!!

Michael

 

[daily106]

Thank you Norie and Michael!
I got it right from cells.

Norie, I will be generating this report on a daily basis, and I thought it will be easier for me if I have the vlookup already included in the part of the "formatting procedures" and also I am trying to learn the basics of VBA. I am learning great from studying your answers on this forum!!!