I added some formatting to Sheet2.colA, and inserted headers in row1
with row CF.

Have a look at "Book3_v2.xlsm" here...

https://app.box.com/s/23yqum8auvzx17h04u4f

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion