To pass argument as argument in VBA macros

Help Studio
2

Datatable is not a variable type within VBA, so you can’t pass that to the macro. You must match variable types.

Here is a post showing a method I’ve used in the past to pass argument parameters to your macro: Passing Argument to Excel Macro - #3 by yuga

It is possible they’ve made it easier to do within UiPath, but that method is still working just fine