![]() |
|
#1
|
|||
|
|||
|
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Help!! find two number recurring numbers in row??
|
carrolld2 | Excel | 5 | 06-28-2014 05:43 PM |
macro to find a character and insert space so autocorrect will expand
|
redzan | Word VBA | 3 | 05-22-2014 04:22 PM |
Help with the "find and replace" option; character problem
|
martinn4 | Word | 3 | 02-20-2014 03:52 AM |
Conditional tied to trying to find a " " space character
|
Dart82 | Word VBA | 3 | 10-04-2013 01:47 PM |
| Concatenated data in subsequent rows | doorsgirl | Excel | 4 | 09-15-2011 10:37 PM |