Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Existence of Comments? (newbie)
- Thread starter gersh
- Start date
SkipVought
Programmer
Hi,
Comments are in a collection. You can loop thru the collection and see if the address of any comment is the address you are "addressing" so to speak...
Hope this helps 
Skip,
metzgsk@voughtaircraft.com
Comments are in a collection. You can loop thru the collection and see if the address of any comment is the address you are "addressing" so to speak...
Code:
For Each Comment In ActiveSheet.Comments
MsgBox Comment.Parent.Address
Nextmetzgsk@voughtaircraft.com
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
