issue with autofit macro on saving to a csv format

Running macro on a work to copy final csv sheet to a new sheet and saves as ms dos csv files.

But I have an issue with the auto fit code I added in bold , it works on the workbook but in saving the file to the desktop,the requested columns are not autofit as it should be .

Can someone look in what is going wrong?

Please Login or Register  to view this content.

Hi leelnich

Thanks for info, it was a personal touch I would like to add to code.

If so , then I will let it as it is.