Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting first blank row
Hi there, From my source file I wish to copy two rows to my target file. They should however not be copied starting at cell A1, but for instance starting at cell A22, if that is the first blank row. What should I write instead of Range ("A1").Select ???? Thanks! Rows("6:7").Select Selection.Copy Workbooks.Open Filename:="c:\Target file.xls" Windows("Target file.xls").Activate --- Range("A1").Select ActiveSheet.Paste |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting first blank row
Great, thanks! "Don Guillett" wrote in : range("a65536").end(xlup).select or range("a1").end(xldown).select "Audio_freak" wrote in message . 35.158... Hi there, From my source file I wish to copy two rows to my target file. They should however not be copied starting at cell A1, but for instance starting at cell A22, if that is the first blank row. What should I write instead of Range ("A1").Select ???? Thanks! Rows("6:7").Select Selection.Copy Workbooks.Open Filename:="c:\Target file.xls" Windows("Target file.xls").Activate --- Range("A1").Select ActiveSheet.Paste |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting first blank row
these will select the last filled row - you want the row one below that
(unless you want to overwrite the last row of data). range("a65536").end(xlup)(2).select or range("a1").end(xldown)(2).select -- Regards, Tom Ogilvy Don Guillett wrote in message ... range("a65536").end(xlup).select or range("a1").end(xldown).select "Audio_freak" wrote in message . 35.158... Hi there, From my source file I wish to copy two rows to my target file. They should however not be copied starting at cell A1, but for instance starting at cell A22, if that is the first blank row. What should I write instead of Range ("A1").Select ???? Thanks! Rows("6:7").Select Selection.Copy Workbooks.Open Filename:="c:\Target file.xls" Windows("Target file.xls").Activate --- Range("A1").Select ActiveSheet.Paste |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting first blank row
Much.
-- Regards. Tom Ogilvy Audio_freak wrote in message . 35.158... "Tom Ogilvy" wrote in news:ub6yUIIdDHA.2112 @TK2MSFTNGP10.phx.gbl: it was indeed the last filled row. i solved it by making a fake last row, and insert the copied data before that row. but this is of course better. THanks ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
Selecting non-blank cells | Excel Discussion (Misc queries) | |||
Selecting the first non blank cell in Range | Excel Worksheet Functions |