Thanks guys!! The "D2" to "D" fixed it. I needed to omit cell D1 as i
was the header to the column and I didn't want it to be effected by th
macro. Now I see why it should just be "D".

My eyes are opened a little wider... :)




sup19

--
Message posted from http://www.ExcelForum.com