Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 05-17-2021, 08:55 PM
Peterson Peterson is offline Looping through comments is slow: inefficiently written code or par for the course? Windows 10 Looping through comments is slow: inefficiently written code or par for the course? Office 2019
Competent Performer
Looping through comments is slow: inefficiently written code or par for the course?
 
Join Date: Jan 2017
Posts: 143
Peterson is on a distinguished road
Default

Thank you for taking a look at and reworking these, Andrew. I could've sworn there was a comments story, but when a quick online search didn't turn it up, I concluded I'd have to loop through each comment. Need to get better at using the object browser...

When searching for names, no, the highlight color isn't important. But I wanted to include the color-specific functionality so that the macro could be used for other purposes, e.g., we occasionally have large, multi-author documents in which highlight colors are used to denote various things, and it'd be useful to be able to selectively clear them.

Thanks again.


EDIT: Your version that tests color ran through my doc with ~430 comments in 15 seconds.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Looping through comments is slow: inefficiently written code or par for the course? Error 4605 when looping through files in folder and deleting comments Peterson Word VBA 2 04-19-2018 08:45 AM
Specific Macro Written brent_bris Excel Programming 0 02-20-2017 05:55 AM
Looping through comments is slow: inefficiently written code or par for the course? Slow internet = Slow Word... User12344321 Word 4 09-21-2015 12:54 PM
Looping through comments is slow: inefficiently written code or par for the course? Need a formula written for me Dbjenkin Excel 1 05-13-2014 05:46 AM
Code Error - Hiding comments and revisions silvrwoman Word VBA 6 03-24-2012 10:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft