Hi
for column A
Cells(rows.Count,"A").End(xlUp).offset(1,0).Select

if you want the last cell in a block, but don't want to jump to a
second block in column A e.g. you have data in A2 to A10 and in A14 to
A20, but you just want the end of the A2 to A10 block then:

Range("A2").End(xldown).offset(1,0).select

regards
Paul

On Feb 25, 3:38*pm, K wrote:
Hi, can anybody please tell that what should be the macro code if I
want to
select next cell of the last value in coloumn. like if i have values
in coloumn "A" then how can i select next cell of coloumn "A" cell
which have the last value.