MACRO CODE
On Feb 25, 3:44*pm, wrote:
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.- Hide quoted text -
- Show quoted text -
thanks paul
|