View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Check cell for comment

Got it. Thanks anyways.

If ActiveCell.Comment Is Nothing Then
MsgBox ("There isn't a comment in this cell to copy!")
Exit Sub
End If

"ExcelMonkey" wrote:

How do I evaluate a cell to see if it has a comment in it. I am not looking
to loop throught a comment collection here. I want to select a cell and
return a property value if possible to see if the cell has a comment. Sounds
sillly as you can see whether it has one or not. But I am using it an error
handler.

Thanks