vlookup VBA code

[fabiogiallo]

Good afternoon,

Please can you suggest me a vba code to replace this one below:

ActiveCell.FormulaR1C1 = "=VLOOKUP(Sheet2!RC[-1],R1C1:R109C19,7,FALSE)"
Selection.AutoFill Destination:=Range("B2:B15693")

this just copy the function to every cell in the column and i don't want this because i have to repeat this for many columns this would affect the size of the file.

Thank you.

 

[Dryver14]

so what do you want it to do instead?

 

[fabiogiallo]

I would like to know if there is a vba code that perform the same action without writing the function on every cell of the column.

 

[Dryver14]

Selection.AutoFill Destination:=Range("B2:B15693"), either delete this line or put an apostophe before it ' to make it a comment

 

[fabiogiallo]

Selection.AutoFill Destination:=Range("B2:B15693"), either delete this line or put an apostophe before it ' to make it a comment

this will just write the vlookup function to the first cell.

 

[Dryver14]

What do you want?
do you want to select the range it puts it into?

 

[Anthony47]

Fabio, hai risolto?
Fabio, did you get the solution?