Max Alphabetical Text String

[rockchalk33]

Hey all, need a little help in VBA using a button and finding the maximum alphabetical text string in a given column. This column is ever changing and could have anywhere from 5 to 1000 active cells.

Thanks,

Devin