Facing problem while trying to set a formula in a desired cell(AZ1) of the sheet. The intention is to get the the last row with values in it, add +1 to it and use the new row to continue writing to the sheet.
Formula : =MATCH(REPT(“z”,255),A:A) + 1
The C# escape sequence doesn’t work over here and unable to assign the same in variable.
Tried to have the formula in Notepad and then copy the contents over to the cell but its giving error like
“System.ServiceModel.FaultException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.”
Would like to have some suggestions over how can this be achieved. After that getcell can be used to use the formula output and continue the automation.
Thanks & Regards,