Extract Comments to Cell and search with AutoFilter
 

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

Extract Comments to Cell and search with AutoFilter
 

I think autofilter only looks at the first 255 characters.

--
Regards,
Tom Ogilvy


"Barb Reinhardt" wrote:

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

Extract Comments to Cell and search with AutoFilter
 

Barb

Tom is correct about the 255 character limit.

For workaround see Debra's site

http://www.contextures.on.ca/xlautofilter02.html#String


Gord Dibben MS Excel MVP

On Thu, 3 Jul 2008 10:06:07 -0700, Barb Reinhardt
wrote:

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