Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RANGE SELECTION
Suppose I want to select a range of empty cells. The following piece of code
also selects the last non-blank cell as well: Range(Selection, Selection.End(xlUp)).Select I want the selection to be of only blanks, in othjer words SHIFT + Down Arrow once. Looking forward for your guidance! Thanx in advance, Regards FARAZ!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RANGE SELECTION
Range(Selection, Selection.End(xlUp).Offset(1, 0)).Select
-- Gary''s Student - gsnu200760 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
RANGE SELECTION
<<Suppose I want to select a range of empty cells.
Where is the current selection? In a range of cells that are already blank, or in the middle of a range of data? <<The following piece of code also selects the last non-blank cell as well: Range(Selection, Selection.End(xlUp)).Select No, it does not. The above code selects from the current selection up to the end of the data block or end of blank cells, depending on where the selection is when you start. <<I want the selection to be of only blanks, in othjer words SHIFT + Down Arrow once. Shift+Down Arrow is conflicting with the code you showed above (xlUp)! Shift+Down Arrow will increase the selection in the DOWN direction, not UP, as performed by the code above. -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
Range(Selection, Selection.End(xlToRight)).Select | Excel Programming | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Creating range name for a range selection | Excel Programming |