I know how to programmatically remove comments from the comment box and put
them in a cell, however, some of these comments are very long and they don't
appear to be displayed in the cell. How can I copy them over so that they
are searchable using the Autofilter functionality? Do I need to put some Alt
Enters into the cells? FWIW, some of the comments are as long as 16000
characters.

Thanks,
Barb Reinhardt