I am using Excel 97 SR2 on an NT system. 800 MHz Compaq with 512 Mb RAM.
I would like to know how to use VBA to consolidate all cell comments found in a worksheet in a blank column of the same worksheet, one comment per cell continuing down until all comments are listed. I read through many posts and did searches on cell comments. I found Post 131532 by grahaml. The thread led me to the VBA code, found at Chip Pearson's site, that will put all the comments into a Word document.
I prefer to have the comments listed down a column to the right of the data. The comment should start with the cell location followed by the actual comment. It is not necessary to include author information.
I can do the code for the correct starting place (including the erasing of old comments), but I am not sure how to convert the macro to put the comments into cells in Excel instead of a Word document.
In reading the posts, I am amazed at how fast and effective Woody