View Single Post
 
Old 05-24-2014, 10:30 AM
NobodysPerfect NobodysPerfect is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Jan 2014
Location: Germany
Posts: 136
NobodysPerfect is on a distinguished road
Default Find max number of same subsequent character

Hi to all,

I'm looking for a quick way to find the maximum number a same subsequent character in a range.

Right now I use the find method to find multiple subseqent spaces, compare the number of spaces found (</>) to current maximum and then continue search: "Do While .Find.Found". This method works, but is rather time consuming.

So my question: any idea(s) how I could speed up my code?

Any help - as usual - would be appreciated

NP
Reply With Quote