Avatar of Fordraiders
Fordraiders
Flag for United States of America asked on

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

Avatar of undefined
Last Comment
Fordraiders

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Steve

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

In 2010 it would be just

rng(i).Comment.Delete
Fordraiders

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