How can I get to this cell

[Graham]

Hi all

I have data in column C, I have a macro that searches for the last entry
which is C325 selects it then finishes. But what I've been trying to do is
when that cell is found is to go left one cell then down one cell. which
wound be B326. My other Problem is when I add new data it will not find that
same cell.

Thanks in advance

Graham

 

[Ron de Bruin]

Try this Graham

Sub aa()
Cells(Rows.Count, "C").End(xlUp). _
Offset(1, -1).Select
End Sub

 

[Graham]

Thanks Ron

Try this Graham

Sub aa()
Cells(Rows.Count, "C").End(xlUp). _
Offset(1, -1).Select
End Sub