| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting entries | Excel Discussion (Misc queries) | |||
| Dependant drop-down lists allowing invalid entries | Excel Discussion (Misc queries) | |||
| Counting cells with Invalid Data | Excel Programming | |||
| Data Validation not preventing invalid entries | Excel Discussion (Misc queries) | |||
| Counting entries | Excel Programming | |||
Threaded Mode
