LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete emty file names from "recent documents" Excel Touble in Excel Excel Discussion (Misc queries) 2 March 22nd 10 08:10 PM
remove emty rows in a table Dan Excel Worksheet Functions 2 February 19th 07 06:30 PM
How to create/run "cell A equals Cell B put Cell C info in Cell D abmb161 Excel Discussion (Misc queries) 5 January 26th 06 06:36 PM
Find emty cell in column and insert value Mikus Excel Programming 3 August 17th 05 01:47 PM
emty excel frame Alex[_13_] Excel Programming 4 January 12th 04 10:06 PM


All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"