Need help writing a simple script for the following excel file attached

I am trying to figure out a way to delete cell C4 and then have i
shift the rows over to the left to lign up like the rest. This is jus
a sample of over a thousand lines. Some have *, some don't. That is th
rub.


Thanks in advance for any help!

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50155
--
Message posted from http://www.ExcelForum.com