I need to sort data in Column A in numerical order from smallest to
largest, and that is correct for any number of rows. So this macro
could be run on a column that has data on rows 3-200, or on rows
3-500.

Does anyone know how to write code in VBA for this in excel 2007?