copy comments to word

[news]

Hi,
I'm having difficulties writing code to copy comments to word.
I'm confused on the "Selection" and/or "Range" Values and how to use them
in this situation.

I need to be able to highlight a range of cells in excel...
Then, copy all the comments in the selected area to a word document.

I have ran across code that will copy the whole workbooks comments but that
is not needed for this.

Thanks for all the help.
Strikker

 

[Word Heretic]

G'day "news" <[email protected]>,

Most of that is an Excel problem.

All you need do on the word side is declare word, open a doc, paste
into it at the end.

Hi,
I'm having difficulties writing code to copy comments to word.
I'm confused on the "Selection" and/or "Range" Values and how to use them
in this situation.

I need to be able to highlight a range of cells in excel...
Then, copy all the comments in the selected area to a word document.

I have ran across code that will copy the whole workbooks comments but that
is not needed for this.

Thanks for all the help.
Strikker

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
wordheretic.com

If my answers r 2 terse, ask again or hassle an MVP,
at least they get recognition for it then.
Lengthy replies offlist require payment.