Error when adding Formula in Excel VBO Set Cell Value

[NicolasSahli]

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!

[_Amlansahoo · Accepted solution]

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 ,

[MichealCharron · Accepted solution]

@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.