copy it to another worksheet
sort the copy
copy back with pastespecial values.

--
Regards,
Tom ogilvy

"havocdragon" wrote:

Hey All, I have ranges I need to sort constantly and I have programmed them
all with macros, however, I have alot of formating that falls apart when I
sort...is there a way similar to pasting special w/values, to sort values
only?