WHen i try to add comment to range of cells, i am facing error.
can any one do help on this.
rng.AddComment "Comment"
WHen i try to add comment to range of cells, i am facing error.
can any one do help on this.
rng.AddComment "Comment"
Delete the existing comment and try...
Use error handler to suppress the error when the cells doesn't have comment.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
as per my knowledge u can add comment to singel cell only
at a time to a ranges of cells u cant add comments
for single cell
Please Login or Register to view this content.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks