Compare column number of a cell with the last cell column number in a loop

Originally Posted by Marc L

Excel can directly save a workbook to a .csv file with Save as command …

Hi Marc,

Thanks for the response! I know that we can save Excel workbook as .csv file. But i need to save .csv with UTF8 encoding which is why i am using the above macro.

I had taken the reference from "http://techspread.wordpress.com/2012/12/05/export-excel-to-csv-in-unicode-utf-8-using-macro-vba/