how to count how many comments in a column

[gigiyi]

Hi experts,

I have a question on how to count how many "commets" I have made in a column.
For instance, In column A, I have 100 data from A1 to A100,
I made a comments on cell A7, A21, A55, A99

My question is how to use formula (not to use VBA code )to count there are total 4 comments in column A?

Thanks in advance.

gigi

 

[Michael M]

I don't believe there is a native function to count comments....you will need to use VBA
Higlight the required column then use

Sub ccom()
MsgBox Selection.SpecialCells(xlCellTypeComments).Count
End Sub

 

[gigiyi]

I don't believe there is a native function to count comments....you will need to use VBA
Higlight the required column then use

Sub ccom()
MsgBox Selection.SpecialCells(xlCellTypeComments).Count
End Sub

thank you Michael, it works.

 

[Michael M]

??