I am creating a csv file in a macro.
There are 12 columns in total but the last 5 columns are blank. The thing is when the file is opened in notepad format the commas should still appear even though in Excel the cells are empty.
E.g. this is how a row of entries should appear if opened in notepad
1,12121,4564,5000,55,094500,T,,,,,
My problem is what can I do to the cells in the last 5 columns in Excel to make them register somehow like this when opened in notepad.
There are 12 columns in total but the last 5 columns are blank. The thing is when the file is opened in notepad format the commas should still appear even though in Excel the cells are empty.
E.g. this is how a row of entries should appear if opened in notepad
1,12121,4564,5000,55,094500,T,,,,,
My problem is what can I do to the cells in the last 5 columns in Excel to make them register somehow like this when opened in notepad.
.FormulaR1C1 = ""
