Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select until blank row
Looking for some advice for the best way to do this. Here's what I did but I
think is cluncky: Windows("MYFILE.xls").Activate If Trim(Range("MASTER!A4")) = "" Then Range("A1:A4").Select Else If Trim(Range("Master!A5")) = "" Then Range("A1:A5").Select Else If Trim(Range("Master!A6")) = "" Then Range("A1:A6").Select Else If Trim(Range("Master!A7")) = "" Then Range("A1:A7").Select Else If Trim(Range("Master!A8")) = "" Then Range("A1:A8").Select Else If Trim(Range("Master!A9")) = "" Then Range("A1:A9").Select Else If Trim(Range("Master!A10")) = "" Then Range("A1:A10").Select End If End If End If End If End If End If End If I want to select all the rows with the last one being the blank row. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Select Blank Cells within a worksheet | Excel Discussion (Misc queries) | |||
Select NON blank cells | New Users to Excel | |||
How do I select & use contents of first non-blank cell in row? | Excel Worksheet Functions | |||
select and delete all blank rows | Excel Discussion (Misc queries) | |||
I want to select the first blank cell in column A | Excel Worksheet Functions |