Need excel help asap

[alexavila_22]

i am having the hardest time figuring this out....

i am trying to create a code or something that will allow me to sort my excel sheet by column A. i have headers from columns A to N.
i would like for it to sort after i fill in in column n but sometimes i wont have information to put in from column I to N until much later.

i hope someone can understand this.
PLEASE HELP ME

thanks

 

[yky]

Try this:

 Range("A1:N" & Sheets(1).UsedRange.Rows.Count).Sort _ 
key1:=Range("A1"), order1:=xlAscending, Header:=xlYes, MatchCase:=False, Orientation:=xlTopToBottom

 

[alexavila_22]

Try this:

 Range("A1:N" & Sheets(1).UsedRange.Rows.Count).Sort _ 
key1:=Range("A1"), order1:=xlAscending, Header:=xlYes, MatchCase:=False, Orientation:=xlTopToBottom

Sadly that does not work at all.

thank you though