excel macro add to collection "Object variable or With block variable not set" code example Example: System.NullReferenceException: 'Object variable or With block variable not set.' Dim x As String