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