Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting A Range
Hi Jason,
These two lines will select from the active cell, to the end of the data range(i.e. last cell that has data, then the same coloumn wise. Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select HTH's. Russ. -----Original Message----- I am trying to write some code that will look at the uppermost cell in a range of cells, and then select the range of cells that belong to the same bunch of data (i.e. all the way to the right of the initial cell until the range ends, and all the way to the bottom of the initial cell until the range ends). Any help would be greatly appreciated. Thanks. Jason . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting a range | Excel Discussion (Misc queries) | |||
Please help with selecting a range | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Selecting a Range | Excel Discussion (Misc queries) | |||
selecting a range | Excel Programming |