View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default 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