Skip to main content

I am using v11 and I need to pass an array variable to macro. My array variable called arr has 3 rows with string type data. The vba method in macro is using the syntax like Sub create_Dyn(ByRef arr() As String). On execution the bot throws an error Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))

Be the first to reply!

Reply