1. select the cells containing the comments and copy them
2. select the destination and paste/special with the comments button checked

This will copy the comments.
--
Gary's Student


"Jack Sons" wrote:

Hi all,

In E2:E650 I have cell comments in most cells, but not in all.
I need code that copies in a super fast way all of them to AA2:AA650. The
cells in AA2:AA650 may already have or have not comments. Can they be "auto
sized" (I don't now if that is the proper phrase) at the same time?

Your help will be appreciated.

Jack Sons
The Netherlands