Counting Invalid entries
 

I am using
Activesheet.CircleInvalid
at the end of a macro. I am wondering if I can count the number of circles
which this command generates and post the number to a cell. For instance,
the following line would be something like
Range("K1")=Activesheet.CircleInvalid.Count (not actual code, just an
example of what I thought the command would be).

TIA, Brad E.

Counting Invalid entries
 

There is no direct way to do it that I know of.
This article from MS provides code that does a count.
(you don't have to add the shape)...
http://support.microsoft.com/default...;EN-US;Q159493
"Macro to Create Data Validation Circles for Printing"
--
Jim Cone
Portland, Oregon USA




"Brad E."

wrote in message
I am using
Activesheet.CircleInvalid
at the end of a macro. I am wondering if I can count the number of circles
which this command generates and post the number to a cell. For instance,
the following line would be something like
Range("K1")=Activesheet.CircleInvalid.Count (not actual code, just an
example of what I thought the command would be).
TIA, Brad E.