About
Pricing
Community
Teams
Start Free Trial
Log in
Fordraiders
asked on
5/5/2014
CLEAR CELL COMMENTS
VBA 2013 EXCEL
i'm simply trying to clear a cells comments after setting to ""
rng(i).Offset(0, 0) = ""
Range(rng(i).Offset(0, 0)).ClearComments
thi is not working ?
Thanks
fordraiders
Microsoft Excel
3
1
Last Comment
Fordraiders
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Steve
5/5/2014
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Martin Liss
5/5/2014
In 2010 it would be just
rng(i).Comment.Delete
Fordraiders
5/5/2014
ASKER
OK thanks !
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
rng(i).Comment.Delete