Code to add a comment and the text from a sheet range
I can easily write code to add a comment to cell C1, with the comment text hard coded.
I am hung up on how to add text to the comment where that text is a variable list of names in cells Range("P2", Range("P2").End(xlDown)).
Also, the text in the comment to be a single name per line.
Thanks,
Howard
|