have a look at the second method using vba
here
http://www.tushar-mehta.com/excel/te...ues/index.html