| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change range from cells to sheet?
Can I change the range from cells to sheet in following. I have problem when
data is bigger than range that macro currently selects, only sorts to 159th line. ? Range("A1:J159").Sort Key1:=Range("B3"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change range from cells to sheet?
n = Cells(Rows.Count, "J").End(xlUp).Row
s = "A1:J" & n Range(s).Sort......... Just replace the address in the Range with the string -- Gary''s Student - gsnu200754 "JBW" wrote: Can I change the range from cells to sheet in following. I have problem when data is bigger than range that macro currently selects, only sorts to 159th line. ? Range("A1:J159").Sort Key1:=Range("B3"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range name: Change from sheet specific to global | Excel Discussion (Misc queries) | |||
| change range of cells to another currency | Excel Worksheet Functions | |||
| How do I change the year in a range of cells | Excel Discussion (Misc queries) | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
| How do you change the size of a range of cells in a column/row | Charts and Charting in Excel | |||
Linear Mode
