Alphabetize Data

[rockchalk33]

Hey all,

Need a little help alphabetizing an unknown amount of data. I have a loop set to insert data at the bottom of a column. This data starts at cell A2 as cell A1 is simply a header. So my question is, how do I alphabetize data (this includes data starting with numerical values) starting at A2 instead of A1 and being able to do this with any arbitrary number of cells. A button will be utilized for doing this and the button is currently set up, I just am a little confused on the sorting code.

Thanks,

Devin

 

[shg]

column("A").sort key1:=range("A1"), header:=xlyes

 

[rockchalk33]

column("A").sort key1:=range("A1"), header:=xlyes

This code will be utilized after a loop in an already created Sub routine and thus when I put in your exact code I am getting a "Compile Error: Sub or Function not defined".

 

[shg]

Sorry:

column[COLOR="#FF0000"]s[/COLOR]("A").sort key1:=range("A1"), header:=xlyes

 

[rockchalk33]

Sorry:

column[COLOR=#FF0000]s[/COLOR]("A").sort key1:=range("A1"), header:=xlyes

Awesome lol! Thanks

 

[shg]

You're welcome.