Hi,
I have started to write a macro to organize my file as I want. I am going to finish it but I have locked a problem.
When I try to write a formula with setFormula, it gives that error Err:508
My Formula: oCellYD.setFormula("=IF((M" & i & "<>"""")," & "O" & i & ",0)")
It looks oCellYD.setFormula("=IF((M" & i & "<>")," & "O" & i & ",0)")
as in libreoffice input line. So adding a "
in the middle ‘<> "
’ => ‘<> ""
’ of formula by hand at input line it fixes.
And also when I Change my formula as oCellYD.setFormula("=IF((M" & i & "<>"")," & "O" & i & ",0)")
It gives #NAME? error. And If add a quotation mark as in Err:508, It fixes.
So my question, how can I fix this issue in macro.