Creating a csv file and showing commas for blank cells

[voodoo]

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.

 

[Andrew Poulsom]

The formula

=""

will do it.

 

[voodoo]

Do you know exactly how to enter this using VBA?

I tried the both following but they didnt work

wksReport.Cells(lngTStartRow, .FormulaR1C1 = ""

wksReport.Cells(lngTStartRow, .Formula = ""

 

[Andrew Poulsom]

This is what the macro recorder spat out:

ActiveCell.FormulaR1C1 = "="""""

 

[voodoo]

Brilliant that did it

Cheers