Counting Invalid entries

B

Brad E.

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.
 
J

Jim Cone

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.aspx?scid=kb;EN-US;Q159493
"Macro to Create Data Validation Circles for Printing"
--
Jim Cone
Portland, Oregon USA




"Brad E."
<[email protected]>
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.
 
Top