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

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

--
Regards,
Tom Ogilvy

"Reinhard F. Bentrup" wrote in message
...
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

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

"Tom Ogilvy" schrieb im Newsbeitrag
...
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

--
Regards,
Tom Ogilvy

"Reinhard F. Bentrup" wrote in message
...
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

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.

--
Regards,
Tom Ogilvy

"Reinhard F. Bentrup" wrote in message
...
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

"Tom Ogilvy" schrieb im Newsbeitrag
...
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

--
Regards,
Tom Ogilvy

"Reinhard F. Bentrup" wrote in message
...
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