Companies House API officers company = dissolved

Hi,

Would anyone be able to help me I'm using a wrapper for the companies house API Kyle123 built to return company information and thanks to Kyle got this to populate officers names into column 9.
However when this runs into a company with a dissolved status the debug displays runtime error 5 which im assuming is down to the company being dissolved and having no active directors.

What i would like this to do is search the status column and return the value "resigned" instead of running the officer search, effectively skipping any with the status value dissolved.

please find attached the before and after spreadsheets.

Thankyou in advance

Duplicate threads are not allowed. Please continue here: https://www.excelforum.com/excel-pro...icer-list.html