That does help, thanks.

I just tried it again and I still can't get it to work. It only work
if Brk appears in the first 4 cells (I increased it to 4) If it appear
in the last four cells it won't move it to the right?

Could you zip me back a copy of a workbook that you have it workin
in?

You can send it to

and thanks agai

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