HOW TO SELECT NEXT CELL OF LAST VALUE CELL

[K]

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

 

[Mike H]

Hi,

Try this

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

Mike

 

[Don Guillett]

try
cells(10,cells(columns.count,10).end(xltoleft).column+1).select