New copy of csv file adds a "," on each cell of column A until the very end

  • Hi, not long ago, i asked for help writing a macro that takes my current workbook and saves a copy of a desired sheet as csv. However, i noticed that the csv file that comes out, is quite odd.
    The original sheet consists of two columns: A which is a product name, and B which is the stock for that product. The resulting csv copy of that sheet ends up being one column that has "product,stock" on column A, until there is no more data, then it is autocompleted by "," on all cells on that row.
    My code thus far looks like this :

    Can anyone help me make it do a normal copy on csv format with no additional cells?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!