I'm tired and going to sleep. Yo can upload the file at

http://tinyurl.com/yc58bw5

When you reply to a message there is a button labeled Manage
Attqhments.

More then one websites share postings. theCodeCage allows
attachments.

I think the problem may be where the data is starting and any headers
you may have in the column. I'm tooo tired to look at the problem
tonight. Mke sure you don't have any data in column c when you run the
macro. Also delete any header row that may exits. Start the 1st data
you posted in cell A1. the code is using the first tab in the
workbook

Set SourceSht = Sheets(1)

This my not be Sheet1

You may want to change to

Set SourceSht = Sheets("Sheet1")


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165111

Microsoft Office Help