For some background.
10k lines of code. Number crunching working. Output partly working, just formatting such as dates and currencies not working.
Using Excel as can't get the budget / IT time for a proper solution.
Some digging in to the code and stepping through on two identical laptops, save for the versions of Excel and O/S.
When running on Excel 2010 the macro copies over the formatting from the origin cell when copying data. Excel 365 does not, hence the different outputs.
I now need to find some time to program the formatting.
|