rows.count

Hello!

I have a range of cells that programe must lookup and is something like this:

Set rng = Range(Cells(2, 11), Cells(Rows.Count, 11).End(xlUp))

So range is starting in row 2 in column 11 till last full cell. I wonder if it is possible that programe would still select cells in column 11 but it will lookup last full cell in column 1?

Thank you and have a nice day!

Set rng = Range(Cells(2, 11), Cells(Cells(Rows.Count, 1).End(xlUp).Row, 11))

should do it.