By using the Comments property of a worksheet it is possible to retrieve the number of comments in said worksheet by accessing its Count property in turn: Worksheets(1).Comments.Count.

The Comment object is a member of the Comments collection containing the following properties: Application, Author, Creator, Parent, Shape and Visible.

Given this information I was only able to retrieve the number of comments per worksheet but would also like to see the ammount and/or ratio of resolved to open comments. Am I missing some hack to utilize the provided properties (maby like Visible) to somehow get information of wheter the comment was marked as resolved?

It is not possible to delete the resolved comments since they are used as some sort of documentation of the decisions and changes.