I want to write a dt while using a Write Range for adding a dt with formulas to a sheet.
When using the Workbook Write Range I will get just the plane text. (Like below)
When hitting enter in the cell (while having Excel open), the formula is accepted. I have read that this doesn’t work with the Write Range from Workbook.
This is why I use the Excel Application Scope. I have debugged it it to the level of knowing that I happens when I use a = in the Write Range. Meaning I can’t write a formula to the sheet. Anybody any advice? Using the 2019.11.0-beta.2 version.
Kr, Paul (NotARobot)