ExcelBanter - Converting cell content into comment

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Converting cell content into comment (https://www.excelbanter.com/excel-discussion-misc-queries/156854-converting-cell-content-into-comment.html)

Akash Maheshwari

Converting cell content into comment

Hi,

I have a sheet in which Leave is mentioned many times in different
cell. I want to have a macro through which i can replace the word
Leave and put a Comment with Leave in the cell How can i do that.

thanks in advance

Akash

All times are GMT +1. The time now is 03:44 PM.