Thread: [Solved] Find and Replace using Excel range
View Single Post
 
Old 04-01-2013, 04:00 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Donna,

With the 'ProcessDates' sub, I didn't get an error message, but I did find that the code got stuck in a loop. That can be fixed by changing:
.Forward = True
and
.Collapse wdCollapseEnd
to:
.Forward = False
and
.Collapse wdCollapseStart

Also (unrelated), with the 'BulkFindReplace' sub, change the first:
Application.ScreenUpdating = True
to:
Application.ScreenUpdating = False
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote