Hi , I am using this formula for getting the last row with values

ws.Cells(Rows.count, rng.Column).End(xlUp).row

Now how can I look for some value in that range ?

Thank you in advance.