ISSUE WITH #NAME ERROR IN VBA CODE FOR EXCEL

Morning, and i just want to say thank you in advance.

VBA how do i count Json objects in an array in excel vba

VBA retrieve object data

I have an object (JS) i my VBA which is returned from using jsonParser function. The data returned is in the image below

Converting Excel sheet into Json

I am very new to Excel macro and need help with the below.