Saving/copying comments to reduce processing time

[ik303]

Dear all,

hello. I have a question that has been troubling me for some time now.

I have an Excel worksheet where I am presenting large amounts of data. The first column (column "A") contains some "static" information that get repeated for a few hundred times. (e.g. A1: gen1, A2: gen2, A3: gen3, A4: gen1 and so on..). I have attached comments to these "headers" that contain a large amount of information.

As it is now, my program keeps going through a loop constructing again and again the same comments and sticking them in the related cells.

I am looking to speed up this process as it is taking to much time.

My question is: is there a way to save or copy the data held in the commentbox so that I can load them/paste them directly to the other cells that will have the same commentary ?

Any suggestion for speeding up the aforementioned process would be greatly appreaciated.

thank you very much or your time and I hope that my question/post makes sense . If you are unclear for sth please do not hesitate to post here for clarifications.

Peace