strange behaviour from vba

Hi Mandeep,
basically i want to see if the field is numeric, and format = currency then change to the selected currency from the drop down in the introduction tab.

the previous codes was working for some reason with the loop, but when i tried to insert it into my original excel file it didnt. here is a the file i managed to get this to work on,

when i move this macro over to the orginal file, it doesnt accept the first currency or leaves it the same, and then it adds junk characters to the bottom of each worksheet right under the table.

your help is greatly appreciated.

thanks,