"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
---