Comment Count

Pinball · Apr 27th, 2002, 01:20 PM

MsgBox ActiveSheet.Comments.Count

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

Thanks.

Jack in the UK · Apr 27th, 2002, 03:43 PM

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

Please explain...

Ivan F Moala · Apr 27th, 2002, 03:45 PM

Quote:

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 · Apr 27th, 2002, 03:57 PM

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

Apr 27th, 2002, 03:43 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	sorry im not answering you post but im intrested as to why? Please explain... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 27th, 2002, 03:57 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	regardless Ivan pops one in,, wanna play for england in the world cup! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 27th, 2002, 01:20 PM	#1
Pinball Board Regular Join Date: Apr 2002 Posts: 107	MsgBox ActiveSheet.Comments.Count How do I change the above to count only comments in Column F? Thanks.