Here is my dilemma. I have a sheet that needs to be formatted in order to be imported to an Access database. I've created a macro to do this, but the problem is that the guy who keeps the sheet up to date keeps adding comments in little comment boxes.
Is there a way to delete all comments from an excel sheet? Like, can I loop through a collection or something?