Adding comments in a range (!) of cells

  • Thread starter Reinhard F. Bentrup
  • Start date
R

Reinhard F. Bentrup

How can I add comments to a range of cells by one (or a few) VBA commands?

I'm having a list of 10000 strings which I need to add as a comment to A1
to A10000. If I add them one after the other it takes about a minute - too
long to wait for.

But I did'nt find a way to insert them in one go. Can I do this like
transfering of an array to a range of cells? This takes just milliseconds.

Thanks - Reinhard
 
T

Tom Ogilvy

Not unless you have them already entered properly on another sheet. If you
do, then you could probably copy and paste them. Look at Edit=>Paste
Special
 
R

Reinhard F. Bentrup

Okay, I copy & paste special works fine.

Do I understand you right that I will be able to add all my comments on
another (new) sheet and then copy&paste?

I need to create my comments by VBA so I do not have them already on a
sheet.

Regards,

Reinhard
 
T

Tom Ogilvy

I said if you have your comments on another sheet you can use copy and paste
special. If you don't then you will have to loop through and add them as
you are doing now. There is no way to paste or assign an array of comments
or anything similar to that that I am aware of.
 
Top