Run Time Error 1004- Long Array Formula in VBA (How to split the code in VBA)

Hello Everyone, I am trying to automate INDEX using Array (Ctrl+Shift+Enter) through macro. but when I run the command, run time error 1004 appears and the code is highlighted with yellow color. ...