Last cell and first emty???!!!
 

I can get the last cell in a range by code below.

Selection.End(xlDown).Select

However, i want the next cell down to paste a selection, i dont want t
paste over data in the lastrow, it should be the first cell, next ro
down.

Any ideas?
Th

--
JohnD
-----------------------------------------------------------------------
JohnDK's Profile: http://www.excelforum.com/member.php...nfo&userid=718
View this thread: http://www.excelforum.com/showthread.php?threadid=48346

Last cell and first emty???!!!
 

Hi John,

Try:

Selection.End(xlDown)(2).Select

---
Regards,
Norman



"JohnDK" wrote in
message ...

I can get the last cell in a range by code below.

Selection.End(xlDown).Select

However, i want the next cell down to paste a selection, i dont want to
paste over data in the lastrow, it should be the first cell, next row
down.

Any ideas?
Thx


--
JohnDK
------------------------------------------------------------------------
JohnDK's Profile:
http://www.excelforum.com/member.php...fo&userid=7184
View this thread: http://www.excelforum.com/showthread...hreadid=483469

Last cell and first emty???!!!
 

How 'bout:
Selection.End(xlDown).offset(1,0).select
HTH

"JohnDK" wrote in
message ...

I can get the last cell in a range by code below.

Selection.End(xlDown).Select

However, i want the next cell down to paste a selection, i dont want to
paste over data in the lastrow, it should be the first cell, next row
down.

Any ideas?
Thx


--
JohnDK
------------------------------------------------------------------------
JohnDK's Profile:
http://www.excelforum.com/member.php...fo&userid=7184
View this thread: http://www.excelforum.com/showthread...hreadid=483469

Last cell and first emty???!!!
 

John,

How about

Selection.End(xlDown).Offset(1, 0).Select

Regards

Pete



"JohnDK" wrote:


I can get the last cell in a range by code below.

Selection.End(xlDown).Select

However, i want the next cell down to paste a selection, i dont want to
paste over data in the lastrow, it should be the first cell, next row
down.

Any ideas?
Thx


--
JohnDK
------------------------------------------------------------------------
JohnDK's Profile: http://www.excelforum.com/member.php...fo&userid=7184
View this thread: http://www.excelforum.com/showthread...hreadid=483469

Last cell and first emty???!!!
 

Selection.End(xlDown).offset(1,0).Select

or

Selection.End(xlDown)(2).Select

--
Regards,
Tom Ogilvy


"JohnDK" wrote in
message ...

I can get the last cell in a range by code below.

Selection.End(xlDown).Select

However, i want the next cell down to paste a selection, i dont want to
paste over data in the lastrow, it should be the first cell, next row
down.

Any ideas?
Thx


--
JohnDK
------------------------------------------------------------------------
JohnDK's Profile:
http://www.excelforum.com/member.php...fo&userid=7184
View this thread: http://www.excelforum.com/showthread...hreadid=483469

Last cell and first emty???!!!
 

Thx guys, i got it.

Much appreciated. :)


--
JohnDK
------------------------------------------------------------------------
JohnDK's Profile: http://www.excelforum.com/member.php...fo&userid=7184
View this thread: http://www.excelforum.com/showthread...hreadid=483469