hi,
yes. see this site.
http://www.contextures.com/xlcomments03.html#Name
you may have to scrool. I haven't been in Debra's site in a while but she's
good on comments.
I would guess that you should be able to loop through the range, adding a
plain comments but you may have to use inputbox to type in the comment.

Good luck
FSt1

"Andrew Hall NZ" wrote:

I use arrays to fill ranges with values all the time because is it is so fast.

targetRange = myarray

Is there any equivalent (or alternative method) for adding a large number of
comments without having to loop through every location in the target range.

It would be nice if the following worked but it doesn't

targetRange.text = myarray

Andrew