Comment Count

[Pinball]

MsgBox ActiveSheet.Comments.Count

How do I change the above to count only comments in Column F?

Thanks.

 

[Jack in the UK]

sorry im not answering you post but im intrested as to why?

Please explain...

 

[Ivan F Moala]

On 2002-04-27 12:20, Pinball wrote:
MsgBox ActiveSheet.Comments.Count

How do I change the above to count only comments in Column F?

Thanks.

MsgBox [F:F].SpecialCells(-4144).Count

 

[Jack in the UK]

regardless Ivan pops one in,, wanna play for england in the world cup!