Merging of excel Cells using invoke

Help
1

hi in this example
it would merge cells using microsoft.office.interop.excel assembly.

Main (2) (1).xaml (13.9 KB)

1 Like
2

Hey, i have actually been looking for a solution like this.
The code seems to work and it does do the merging as instructed, the only issue is that it ends up throwing a runtime error of System.Reflection.TragetInvocationException.

ExampleImage

Any ideas on how to fix this issue?

Edit: Nvm, the issue was because i didnt have a “sheet2” which caused the error!