Checking for a blank cell when using SetSharedFormula

I kept getting a "No overload for method 'SetSharedFormula' takes 4 argument" error. Can someone see what is wrong with the following formula/suggest a solution


cells["AL2"].SetSharedFormula("=IF(ISBLANK(B2),"",VLOOKUP($B2,SLA,2,FALSE))", 128, 1);

Hi,


Thanks for your query.

Please change the line of code to:
cells[“AL2”].SetSharedFormula("=IF(ISBLANK(B2),"",VLOOKUP($B2,SLA,2,FALSE))", 128, 1);

Let us know if you still have any issue.

Thank you.

Thanks Sahi, the suggested solution worked.

Hi,


Good to know that your issue is sorted out by the suggested line of code. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.