Copy comments and paste as text

**Solomon14all** · 10-30-2012, 06:21 AM

Hi every one,

is it possible to copy only the comments and paste as text

Thanks.
Raj

**Solomon14all** · 10-30-2012, 06:44 AM

B1-B11 contains comments, i want to copy the comments and paste as text in c1-c11 will any one help me.

Thanks Raj.

**:) Sixthsense :)** · 10-30-2012, 06:50 AM

Originally Posted by Solomon14all

is it possible to copy only the comments and paste as text

Try the below code in standard module

Please Login or Register  to view this content.

Above code will get the activesheet comments Column-A

**Pepe Le Mokko** · 10-30-2012, 06:56 AM

Have a look at this link

**:) Sixthsense :)** · 10-30-2012, 07:06 AM

Originally Posted by Solomon14all

B1-B11 contains comments, i want to copy the comments and paste as text in c1-c11 will any one help me.

Refer the attachment file for solution.

**Solomon14all** · 10-30-2012, 07:24 AM

i tried but do not know how to copy the code. will you please copy the code in the attached sheet and resend to me.

Thanks
Raj.

**:) Sixthsense :)** · 10-30-2012, 07:39 AM

Originally Posted by Solomon14all

i tried but do not know how to copy the code. will you please copy the code in the attached sheet and resend to me.

Refer my another post in which I have posted the file with code.

Re: Copy comments and paste as text