View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Sub to write cell contents into its own comment

I would select a range of cells, then run the sub to write each cell's
content into its own comment. The sub to do nothing for any cell within the
selection which is blank. For cells which contain formulas, to write the
returned values into the comment. Thanks for insights