Excel doesn't allow comments to be copied
Hi,
I'm in a big confusion and I need help!
In a VBA application in Excel I wrote some statement like
this:
"fromRange.Copy
toRange.PasteSpecial Paste:=xlPasteComments"
where, as you probably guessed, "fromRange" and "toRange"
are range objects.
Unfortunately, časte instruction doesn't work. The
comments, defined in "fromRange", aren't copied
into "toRange" as I expect.
Could someone help me to solve this mistery?
Thank you in advance!
Mike
|