Hi,

Try this

Sub versive()
lastrow = Cells(Cells.Rows.Count, "A").End(xlUp).Row
Cells(lastrow, 1).Offset(0, 1).Select
End Sub

Mike

"K" wrote:

Hi, in macro how you can select the next cell of the last value cell
in coloumn
For example If I have value in cell A1 to A10 then how can I select
next cell
of cell A10 which will be B10.
Please if anybody can help