@Emmy_O , Check the below post :
We can use the function name itself for the assignment and get the output in the Invoke VBA Activity.
But I would also ask to give a try using the Append Range Activity to check if that can be an alternate/ would be a better approach if pasting the data at the end is all you need.