in new sheet named "DATA1" , i was download this file from john's post at "http://www.excelforum.com/excel-prog...s-to-rows.html" and modify the target content and after that on line 100 of my previous post's attachment give me the error.