Is there a way to count how many cells in a row have comments in them ? Anthony G
M Mr Anthony Griffiths Nov 4, 2004 #1 Is there a way to count how many cells in a row have comments in them ? Anthony G
R Ron de Bruin Nov 4, 2004 #2 Hi Anthony Example for row 1 on the activesheet On Error Resume Next MsgBox Rows(1).SpecialCells(xlCellTypeComments).Count On Error GoTo 0
Hi Anthony Example for row 1 on the activesheet On Error Resume Next MsgBox Rows(1).SpecialCells(xlCellTypeComments).Count On Error GoTo 0
