| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting sheet problem
Is it possible to sort a worksheet with out actually making it the active
sheet? The sheets name is "dayoptions" and I want to sort column a into ascending order Thanks in advance Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting sheet problem
Sure. Something like:
With Worksheets("dayoptions") .Range("A1:A1000").Sort Key1:=.Range("A1") End With -- Vasant "browie" wrote in message ... Is it possible to sort a worksheet with out actually making it the active sheet? The sheets name is "dayoptions" and I want to sort column a into ascending order Thanks in advance Greg |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting sheet problem
Thank you exactly what i needed
Greg "Vasant Nanavati" <vasantn AT aol DOT com wrote in message ... Sure. Something like: With Worksheets("dayoptions") .Range("A1:A1000").Sort Key1:=.Range("A1") End With -- Vasant "browie" wrote in message ... Is it possible to sort a worksheet with out actually making it the active sheet? The sheets name is "dayoptions" and I want to sort column a into ascending order Thanks in advance Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting problem | Excel Discussion (Misc queries) | |||
| Problem with sorting | Excel Discussion (Misc queries) | |||
| automatic column sorting problem when protecting sheet | Excel Worksheet Functions | |||
| Problem created by sorting linked sheet | Excel Discussion (Misc queries) | |||
| Copied empty cells, give sorting problem in Data sheet | Excel Programming | |||
Linear Mode
