Thanks, Bob --
If the data continued in, say, ranges ("A:A"), ("C:C"), ("E:E"), etc., I
can use your approach to sort each individual range. But if for example,
"A:A" has about a 1000 empty cells below its last entry and I need to
"pad" or fill those cells with the data in "C:C" until it is full and
continue in "C:C" from "E:E" until it is full, and so on, how will I
modify the code to execute this

This scenario has a very good possibility of occurring and I need to
prepare for that as well. I will appreciate any help.

Thanks again.
Jay



*** Sent via Developersdex http://www.developersdex.com ***