Thread: [Solved] Need to improve speed of Excel macro that searches for whole word matches
View Single Post
 
Old 02-16-2016, 10:31 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
I'd look into the use of range.Find and .FindNext methods.
Reply With Quote