Posts by overdrive

    Sorry to relive such an old issue but wanted to explain why the code is invalid. In that code there are one implicit error that does not let debugging of shadow error.

    According to Microsoft documentation, the necessary argument for Range from the Shapes collection requires an array (of indices or text). Therefore, it must be explicitly declared as such, so Dim vntShapeName as Variant must become Dim vntShapeName() as Variant.…ba/api/Excel.Shapes.Range

    Now, if you execute debugging then VBE will info about of shadow error, you can not directly assign to matrix. This code is correct: