Record as a macro the following steps:
Select all cells
Copy
Select new sheet
Pastespecial Comments
Regards,
Stefi
€˛shanelaura€¯ ezt Ć*rta:
I would like to create a macro to get the commnets out of each cell and
then add and display in another worksheet
--
shanelaura
------------------------------------------------------------------------
shanelaura's Profile: http://www.excelforum.com/member.php...o&userid=33898
View this thread: http://www.excelforum.com/showthread...hreadid=536733