excelでの汎用的な利用に関して（計算式コピー）：On general use in excel (formula copy)

日本 フォーラム
1

excelで最終行の次の行にデータを貼り付けます。
青色のセルの範囲
その後、計算式を貼り付ける前の最終行のセルを利用してコピーして貼り付けたいと思います。
貼り付け元：D3:E4
貼り付け先：D4:E6
緑色のセルの範囲

invoke codeを利用してこのような処理を汎用的に利用と考えています。
vb.netの知識なく頓挫しています。
AからC：データエリア
DからE:計算式エリア

uipathでの実現方法ご教示いただければと思います。

Paste the data on excel to the next line after the last line.
Range of blue cells
After that, I would like to copy and paste using the last row of cells before pasting the calculation formula.
Pasting source: D3: E4
Pasting destination: D4: E6
Range of green cells

We use invoke code to consider such processing as general purpose.
I am abandoned without knowledge of vb.net.
A to C: Data area
D to E: calculation formula area

I think that you can teach how to realize with uipath.excel

2

sample.xaml (7.5 KB)
文法エラーはなくなりましたが実行時エラーがでます。
エラー内容：

The syntax error no longer exists, but a runtime error occurs.
error contents
sample has thrown an exception
Source: Invoke code
Message: Exception has been thrown by the target of an invocation.
Exception Type: TargetInvocationException

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.NullReferenceException: Object reference not set to an instance of an object.
at UiPathCodeRunner_39d7c5a185dd47b58a091ed1617a27ad.Run(Application app, Workbook workbook, Worksheet xlsheet, Range xlrange, GC gc, Range xlPasteRange)
— End of inner exception stack trace —
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object providedArgs, ParameterModifier modifiers, CultureInfo culture, String namedParams)
at UiPath.Core.Activities.Workflow.CompilerRunner.Run(Object args)
at UiPath.Core.Activities.InvokeCode.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)