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