Copying excel cells as comments

[hsingh78]

Hi,

I am new to this forum and facing an issue with my excel work. I have some data in 100 of columns and which will go as comments to another sheet in a row. Is there a way that we can just copy and paste cell value as comments.

I know with paste special we can copy comments but my request is to copy the cell content as comments to lot of cells. Otherwise i have to do them one by one.

Any suggestions and help would be highly appreciated.

Thanks in advance

[Alf]

You could try something along these lines:

Please Login or Register  to view this content.

This code takes the cell value from cell D5 and pastes it as a comment in cell D8.

Still to get the best response to your question you should upload a sample workbook showing raw data and desired result.

Alf