I'm having trouble creating a macro that will sort a column of values.
There is information in the first few rows that should not be sorted
and totals and other information in rows after the data that shoul
also not be sorted.

To manually do the command I would anchor the start of the range an
use the 'down arrow' and then the 'end' key. How do I do that in
macro?

The problem is that rows in the middle of the range are always bein
added or deleted so it is a dynamic range. I had no success with th
offset command as it doesn't (or didn't the way I was using it) wor
when you have data below the list that can't be part of the range.

Any ideas

--
Message posted from http://www.ExcelForum.com