Range for Vlookup: refer to columns stored in a variable

[stefy1984]

Hi,
I’m new in the VBA world and in this forum. I’m trying to do a vlookup but I’m facing a problem
I need to refer to a range in another worksheet. The columns to which I want to refer can vary position. Therefore I get their column number and store it in a variable (ColC, ColN)
I don’t know how to refer to the range. If I refer to the range by the letter of the columns, the vlookup works.

Cells(i, 2).Value = Application.WorksheetFunction.VLookup(Cells(i, 1).Value, Sheets("S1").Columns("B:E"), ColVLU, False)

However these columns can move and I need to find a way to refer to this range without using (“B:E”).
I’ve tried this but it doesn’t work

Cells(i, 2).Value = Application.WorksheetFunction.VLookup(Cells(i, 1).Value, Sheets("S1").Range(Columns(ColC), Columns(ColN), ColVLU, False)

Any suggestion? Thanks a lot for the help!