View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Copy cell to another as a comment

"rpick60" wrote:
in column I i may have "Lifter" and column J would have "2 IN stroke"
I would like Column I to stay the same with a Comment of "2 IN Stroke"


Think there's a Sub AddComments() at David McRitchie's page
which you could use:
http://www.mvps.org/dmcritchie/excel/ccomment.htm

Scroll down about 1/3 on that page, look for:
Macro to populate comments in a range with text values of another range
(#addcomments)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---