| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Last Empty Row / Certain Columns
Hey,
I have this where it finds the last empty cell Worksheets(Sheet10.Name).Cells(Rows.Count, 1).End(xlUp).Select ect basically it selects the last empty cell in the worksheet. However I need it to select the last empty row but only columns A/B/C/D/E I tried changing it to Worksheets(Sheet10.Name).Range("A:E").End(xlUp).Se lect but that does no go. Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting Last Empty Row / Certain Columns
Try something like this:
r= Worksheets(Sheet10.Name).Cells(Rows.Count, 1).End(xlUp).row Worksheets(Sheet10.Name).Range("A" & r & ":E" & r ).Select "RigasMinho" wrote in message ups.com... Hey, I have this where it finds the last empty cell Worksheets(Sheet10.Name).Cells(Rows.Count, 1).End(xlUp).Select ect basically it selects the last empty cell in the worksheet. However I need it to select the last empty row but only columns A/B/C/D/E I tried changing it to Worksheets(Sheet10.Name).Range("A:E").End(xlUp).Se lect but that does no go. Any ideas? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting Last Empty Row / Certain Columns
Worksheets(Sheet10.Name).Cells(Rows.Count, 1).End(xlUp).Resize(1,5).Select
-- Regards, Tom Ogilvy "RigasMinho" wrote: Hey, I have this where it finds the last empty cell Worksheets(Sheet10.Name).Cells(Rows.Count, 1).End(xlUp).Select ect basically it selects the last empty cell in the worksheet. However I need it to select the last empty row but only columns A/B/C/D/E I tried changing it to Worksheets(Sheet10.Name).Range("A:E").End(xlUp).Se lect but that does no go. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting next empty cell | Excel Discussion (Misc queries) | |||
| Automatically selecting the next empty row | Excel Discussion (Misc queries) | |||
| Finding next empty empty cell in a range of columns | Excel Programming | |||
| Selecting the first empty row | Excel Programming | |||
| Selecting the first empty row | Excel Programming | |||
Linear Mode
