I'm trying to find a value in a particular column. The code that I use is

Match_Row = Application.WorksheetFunction.Match("460", ws.Range("AB:AB"), 0)

The range changes as the code runs so I can't use a fixed range so using "AB:AB" won't work. So when the first part of the code finds a cell with a predefined background color and has a value greater than 0 in range "Range(Cells(Z_Row, X_Col), Cells(Z_Row, Y_Col))" then it then searches in AB for the matching cell value that is in "A" & activerow.

Since my loop ends with X_Col = X_Col + 1, I need a Match or Vlookup code that also can have the same sequence increase of X_Col

I hope I explained properly.