ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can comment indicators be counted? (https://www.excelbanter.com/excel-programming/287870-can-comment-indicators-counted.html)

Candee[_18_]

Can comment indicators be counted?
 
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

--
Message posted from http://www.ExcelForum.com


KJTFS[_26_]

Can comment indicators be counted?
 
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

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 11:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com