I am using a loop to populate multiple cells on a cell by cell basis and some of the cell formats are changing to a date format despite being formatted as a number.
This seems to happen for a block of cells in a column and also formats a number in a call in the column that isn't manipulated via the code. I.e. the code starts to added data from row 8 but some values I have in row 4 (that holds the column numbers I need to pass into the code) also get changed.
It doesn't apply the date formats to all the cells in a column and will stop after what seems to be a consistent 10 rows, so rows 4 to 18 are changed to a date format.
I am at a complete loss as to why this is happening and I don't want to add additional code to amend the cell format as there are potentially 120+ columns and 10k rows where data can be added.
TIA
This seems to happen for a block of cells in a column and also formats a number in a call in the column that isn't manipulated via the code. I.e. the code starts to added data from row 8 but some values I have in row 4 (that holds the column numbers I need to pass into the code) also get changed.
It doesn't apply the date formats to all the cells in a column and will stop after what seems to be a consistent 10 rows, so rows 4 to 18 are changed to a date format.
I am at a complete loss as to why this is happening and I don't want to add additional code to amend the cell format as there are potentially 120+ columns and 10k rows where data can be added.
TIA