error 1004

as my first message in my forums and breaking the forum rules i need to say , ive download the xls file from this address : http://www.excelforum.com/excel-prog...s-to-rows.html and got this error . im really sorry for inconvience but im in hurry ,... can you help me ?

thank you for reply , i need to split the separated-comma rows (text to rows) but that gives me "Application defined or object defined error". you can see the attachment ..

thanks again