| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count Comments
Is there a way to count how many cells in a row have comments in them ?
Anthony G |
|
#2
|
|||
|
|||
|
Hi Anthony
Example for row 1 on the activesheet On Error Resume Next MsgBox Rows(1).SpecialCells(xlCellTypeComments).Count On Error GoTo 0 -- Regards Ron de Bruin http://www.rondebruin.nl "Mr Anthony Griffiths" wrote in message ... Is there a way to count how many cells in a row have comments in them ? Anthony G |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Comments be automatically converted to text cell values? | Excel Discussion (Misc queries) | |||
| filter and count | Excel Discussion (Misc queries) | |||
| How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
| count based on two fields - need quickly | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
