Find max number of same subsequent character

[NobodysPerfect]

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