See if this will help...

http://www.contextures.com/xlcomment...ml#CopyToSheet