Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2020, 03:49 PM
Chopper Chopper is offline MS WORD search macro slows way down as it runs Windows 10 MS WORD search macro slows way down as it runs Office 2019
Novice
MS WORD search macro slows way down as it runs
 
Join Date: Dec 2020
Posts: 16
Chopper is on a distinguished road
Default

Epigram - Finally solved the speed problem by using the following approach:

dim p as Paragraph
-
-
for each p in p.activedocument.paragraphs
pgphRange = p.Range.test
-
-
yadda, yadda processing contents of pgphRange ...
-
-
Next p

Runs like lightning (8000+ lines/paragraphs in under 10 seconds!), no need to delete processed lines/paragraphs, less code, whiz-bang!

I'm such a dumb@ss for not figuring this out 3 days ago.



Thanks all for helping to point me in the right direction.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
MS WORD search macro slows way down as it runs Bold Button Runs Macro DRD992 Word VBA 1 11-22-2017 02:23 PM
MS WORD search macro slows way down as it runs Word slows down as file size increases johnmill@dymeroaks.net Word 3 02-05-2016 05:49 PM
MS WORD search macro slows way down as it runs Word periodically slows / freezes when typing or printing KathyReid Word 3 09-26-2015 10:49 AM
MS WORD search macro slows way down as it runs Help:word editing slows down when copying a block diagram seeker_123 Word 1 03-02-2015 09:26 AM
MS WORD search macro slows way down as it runs Word slows to a crawl. traumatiziert Word 1 04-18-2012 12:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:07 PM.


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