Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting the first empty row
Correction
use Sheets("Sheet2").Range("A65536").End(xlUp).offset( 1,0) as destination will do -- Regards KC Cheung The Inglewood "KC Cheung" wrote in message news:... use Sheets("Sheet2").Range("A65536").End(xlUp) as destination will do -- Regards KC Cheung The Inglewood "Norman Jones" wrote in message ... Hi Webba, Try something like: Dim srcRng As Range Dim destRng As Range Set srcRng = Sheets("Sheet1").Range("A10:H15") Set destRng = Sheets("Sheet2"). _ Cells(Rows.Count, "A").End(xlUp)(2) srcRng.Copy Destination:=destRng --- Regards, Norman "webba" wrote in message ... How do I select the first empty row in a worksheet? I'd like to copy a certain range form wksheet 1 and then past that range into the next available row in wksheet 2. Thanks! Weber -- webba ------------------------------------------------------------------------ webba's Profile: http://www.excelforum.com/member.php...o&userid=26250 View this thread: http://www.excelforum.com/showthread...hreadid=395463 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting data €“ when some cells are empty | Excel Discussion (Misc queries) | |||
Selecting occupied cell over empty ones | Excel Discussion (Misc queries) | |||
selecting next empty cell | Excel Discussion (Misc queries) | |||
Automatically selecting the next empty row | Excel Discussion (Misc queries) | |||
Selecting the first empty row | Excel Programming |