Increase Cell in VLookup

[smund]

Please,


ActiveCell.Value = "=VLOOKUP(a3,QuadroPacientes,2,FALSE)"

How to increase the cell A3 to A4, ...when I fill a column.

 

[bjurney]

The Row will automatically update when you autofill it as long as you dont make your value absolute ($).

ActiveCell.AutoFill Destination:=Range("A1:A23"), Type:=xlFillDefault

Depending on where you need it to fill the formula, you can adjust as needed.

 

[Marcelo Branco]

Hi, (Oi)

Assuming your names (vlookup_value) in A3:A5 and the results in B3:B5 try this

Sub Test()
    Dim rng As Range
    
    Set rng = Range("B3:B5")
    
    rng.Formula = "=VLOOKUP(A3,QuadroPacientes,2,FALSE)"
    
End Sub

M.

 

[smund]

Thanks, very much.