Skip to main content
Question

Pass Array variable to excel macro

  • September 12, 2024
  • 0 replies
  • 44 views

Forum|alt.badge.img

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))