Thanks Guys it really worked!! here is another question what if i want to extended the sorting to column J as Column A Numbers have information extended till column J.
I am trying to learn about Range- eventually wanna sort column A to J and highlight the duplicates.
Thanks a lot..