Can comment indicators be counted?

[Candee]

Good morning all

Not sure if this can be done or not, but what I would like to do is pu
a formula in a cell on a worksheet to count the number of commen
indicators (or comments) in a range on the same worksheet.

:confused

 

[KJTFS]

I don't know about a standard excel function but you could set up a use
defined function and return the property

.comments.count


that will give the number of comments


Keith
www.kjtfs.co