topic Re: Error when adding Formula in Excel VBO Set Cell Value in Digital Exchange

Error when adding Formula in Excel VBO Set Cell Value

NicolasSahli — Thu, 21 Mar 2024 07:37:37 GMT

Hello

I have encountered an error when inserting a "SUBTOTAL" formula in an Excel sheet.

If I use the formula for example "=SUBTOTAL(9;Q1:Q10)" i get following Error:
Exception from HRESULT: 0x800A03EC

If I use a "SUM(Q1:Q10)" formula it works perfectly

I need the SUBTOTAL formula since its applied on a filtered excel sheet.

Anyone knows a solution to this or another way to get this formula to the cell needed?

Thank you!

Re: Error when adding Formula in Excel VBO Set Cell Value

_Amlansahoo — Thu, 21 Mar 2024 11:01:11 GMT

Hi @NicolasSahli , I guess you wrote the wrong formula for subtotal. It should be "=SUBTOTAL(9,Q1:Q10)". You have used semicolon ; instead of comma ,

Re: Error when adding Formula in Excel VBO Set Cell Value

MichealCharron — Thu, 21 Mar 2024 17:23:31 GMT

@NicolasSahli

I'm guessing that the region format that your system is set to has ";" as your list separator. Unfortunately, as @_Amlansahoo has pointed out, you will have to use "," as your parameter separator when passing formula's through the actions. It will show up as ";" once it gets into the cell.