sort macro
 

Hi
how i can write a macro to sort colume E sort from Ato z

sort macro
 

You can do it w/o a macro using the menu Data | Sort. If you want a
macro, use the macro recorder.

Merjet

sort macro
 

Or you can use the example in the VBA help files:

Sub SortRange()
Worksheets("Sheet1").Range("E1").Sort _
Key1:=Worksheets("Sheet1").Columns("E"), _
Header:=xlGuess
End Sub


"bijan" wrote:

Hi
how i can write a macro to sort colume E sort from Ato z

sort macro
 

thank you
it worked but i want when Excle open it automaticaly run this macro .
the name of my macro is Sort