Hi,
I have a problem when posting a formula to excel. Getting an 0x800A03EC error in one case (when posting the original format after changing which cells I'm referring to) and #NAME? error when posting with "," instead of ";" that i tried because of divider problems. Even if i just read then post the formula without manipulate it i get the 0x8... error.
The formula in question: =INDEX(B2:B7;TYPVÄRDE(PASSA(B2:B7;B2:B7;0))) and it works if i post it manually to excel.
Running windows 10 with Swedish language and localization and Swedish excel.
I need to find a solution since i can't change anything but the language due to not knowing the impact of changing for instance format setting has for the applications I'm using in the automations.
Anyone has any tips regaring this?
------------------------------
Daniel Litfeldt
------------------------------
