Link to home
Get AccessLog in
Avatar of Fordraiders
FordraidersFlag 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
ASKER CERTIFIED SOLUTION
Avatar of Steve
Steve
Flag of United States of America image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of Martin Liss
In 2010 it would be just

rng(i).Comment.Delete
Avatar of Fordraiders

ASKER

OK thanks !