Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Till last row
Hi
I used the following code in a macro Range(Selection, Selection.End(xlDown)).Select 'the same as CTRL-SHIFT-DownArrow This does not work if there is emty rows (only selects till it finds the first emty row) Is there another function to select till the last row that is populated ? Thanks a lot Alfred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Till last row
you can try this
Range(Selection, Cells(Rows.Count, Selection.Column).End(xlUp)).Select -- Gary "Alfred" wrote in message ... Hi I used the following code in a macro Range(Selection, Selection.End(xlDown)).Select 'the same as CTRL-SHIFT-DownArrow This does not work if there is emty rows (only selects till it finds the first emty row) Is there another function to select till the last row that is populated ? Thanks a lot Alfred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop till value changes | Excel Discussion (Misc queries) | |||
Looping till value is 1? | Excel Discussion (Misc queries) | |||
Locating the row that has no values. Selecting that row till the last row after that and deleting it? | Excel Programming | |||
SUM C IF B=Cap... Till Next B=Cap... | Excel Worksheet Functions | |||
SUM C IF B=Cap...TILL NEXT B=Cap... | Excel Worksheet Functions |