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 |
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 |