Hi everyone,
I've got some code that runs through a column and checks to see if the number is < than the other one..
My problem is the fact that sometimes the criteria isnt always less than is there a way i can change the operator to a cell (value?) (I.e could be > or <)
Many thanks in advance!Do While (Cells(f, 2).Value <> "") If Cells(f, fCol + lCol).Value < Cells(f, fCol).Value Then counter = counter + 1 Set Missed(counter) = Cells(f, 1) ReDim Preserve Missed(1 To counter + 1) End If f = f + 1 Loop
Bookmarks