how to copy cell contents ( comments) into new cell

I have lot of data with comments attached to it
I want to sort ot the same in new sheet for which i need to copy cell contents with comments using formula or macro. w/o using normal copy paste option. could some one help me on this.

206598

Rahul , what i need is to do without this option.
let me give you example. I want to copy all contents ( comments) from cell A2 to cell B2 w/o using copy paste option how will you do.

Originally Posted by Rahul Nagar

Hello,

I guess

Select your entire column and copy it. Select the cell in the first row of any other column and go to Edit>PasteSpecial-Comments.

Hi,
You can use the following code and run a macro to copy the contents of the with comments.

Range("A1:A10").Select
Selection.Copy
Range("F18").Select
ActiveSheet.Paste

Thanks