Hi,

I am trying to collect comments from sheet1!A1:A30 in sheet2, but not all
cells in A1:A30 contains a comment but are blank.
How do I automatic get sheet2 to collect all comments and only the comments
from sheet1?
I have tried using the ISTEXT, but it can't be used on a range.

Hope someone can help me, thanks!

In sheet1 select cells A1 thru A30 and copy them.
In sheet2 select cell A1 and:

Edit PasteSpecial comments

only the comments will be copied over, not the values in the cells
--
Gary''s Student - gsnu200724


"mia_kit" wrote:

Hi,

I am trying to collect comments from sheet1!A1:A30 in sheet2, but not all
cells in A1:A30 contains a comment but are blank.
How do I automatic get sheet2 to collect all comments and only the comments
from sheet1?
I have tried using the ISTEXT, but it can't be used on a range.

Hope someone can help me, thanks!

By "Comments" do you mean those created by InsertComment?

Or just text string in the cells?

If the first, see Debra Dalgleish's site for code.

http://www.contextures.on.ca/xlcomme...ml#CopyToSheet

If the second, select A1:A30 and F5SpecialConstantsOK

EditCopy then paste.

Not automatic, but you could record a macro whilst doing this.


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 08:13:05 -0700, mia_kit
wrote:

Hi,

I am trying to collect comments from sheet1!A1:A30 in sheet2, but not all
cells in A1:A30 contains a comment but are blank.
How do I automatic get sheet2 to collect all comments and only the comments
from sheet1?
I have tried using the ISTEXT, but it can't be used on a range.

Hope someone can help me, thanks!