All,

In trying to finish off this macro and I am trying to find a way to do a
sort on a range. The column that I am sorting by is always teh same, but
the range will vary. Is there a way in VBA to pass along that range
variable to sort? I would ideally like the input box to be where you can
click the box on the right to select your own range from within excel and it
will populate that range automatically. Then that range would be passed
along to the sort macro. Any help would be greatly appreciated.

Nathan Bell