VBA - Vlookup formula - make column index dynamic

[anglais428]

Hi,

I would like to make the column index number based on the last column of a sheet inside the vlookup formula. Is this possible?
Currently formula (only displaying part of it):
Round(F2/VLOOKUP(B2,Total!$B$2:" & Cells(LRtotal, LCtotal).Address(True, True) & ",17,0)

I would like to change the 17 to LCtotal, which is already defined (it should output 19) LCtotal = Sheets("Totals").Cells(1, Columns.Count).End(xlToLeft).Column

The formula is within a ".Formula = " piece of code

Thanks

 

[anglais428]

Solved. Please close thread.