View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad E. Brad E. is offline
external usenet poster
 
Posts: 76
Default 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.