Count Comments

  • Thread starter Mr Anthony Griffiths
  • Start date
M

Mr Anthony Griffiths

Is there a way to count how many cells in a row have comments in them ?

Anthony G
 
R

Ron de Bruin

Hi Anthony

Example for row 1 on the activesheet

On Error Resume Next
MsgBox Rows(1).SpecialCells(xlCellTypeComments).Count
On Error GoTo 0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a comment in a footnote area 1
How to have two tables on same line? 1
Using @ in comments: is there a way to get only one email? 0
Managing multiple jobs in a fabrication shop 0
How to count the numbers in a Word document? 0
Merging from an Excel file with graphics 1
Automation of scanned file storage based on content 0
Unclear change tracking process 0

Top