LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default How to judge some cell that had been added comments?

Hi,
I write a macro. It add comments into some specific cells. After added
comments, I want to update comments by AddComment() method. It appear error.
So I must judge the cells whether had been added comments. Would you tell me
which methods are able to implement it? Thank you very much!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel and searching for a string in a cell where comments have been added sammy[_2_] Excel Discussion (Misc queries) 1 August 7th 11 12:23 PM
Allow comments to be added to protected worksheet? - Excel 2007 sue@solotel New Users to Excel 1 November 5th 09 12:21 AM
Delete added comments Doman Excel Discussion (Misc queries) 3 July 18th 06 12:29 PM
How to judge wheter an object is existing or not lvcha.gouqizi Excel Programming 6 November 1st 05 09:32 PM
Searching within comments added to cells red6000 Excel Programming 2 July 22nd 05 01:28 AM


All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"