Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to select a variable range, beginning in column A and ending in
the furtherest column to the right being used AND last row used. There are three factors to remember: 1) The actual beginning point (upper leftmost cell) may change as I insert/delete rows above the data to be sorted. The first cell in column A for the sort range is located below the header FREQ. 2) The number of rows down will increase as data is added. 3) The number of columns used may increase if I determine there are other items I need to calculate/input. Currently, I am using columns A-R. The column headers are on row 8, which may increase/decrease based on item #1 above. One other quick question: I believe I have the sort code I need. My question is this: After the range is selected, I believe the first part of the sort code is "Selection:Sort" (without quotes). Is this correct? Thanks for your help! Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |