View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mark Lincoln Mark Lincoln is offline
external usenet poster
 
Posts: 227
Default String manipulation in macro runs slower each time ran.

Without knowing the context in which you're running this, I have to
guess that you may be moving growing amounts of text each time you run
this code. Do you run it from the top of a column every time, thereby
moving all your previous text down with each pass through the loop?

BTW, in testing this in Excel 97 I had to change the first line to get
the loop to end properly:

Do Until (ActiveCell.Value) = Empty