+ Reply to Thread
Results 1 to 7 of 7

Replace Macro is really slow

  1. 02-25-2011, 01:32 PM #1
    SandiM
    SandiM is offline
    Registered User
    Join Date
    02-25-2011
    Location
    Dallas
    MS-Off Ver
    Excel 2003
    Posts
    4

    Replace Macro is really slow

    I have a spreadsheet with approx 20k records and 15 columns of data. I've written a Replace Macro but it sends excel in to 'Not Responding' mode. How can I speed it up? I appreciate any help or tips!! 
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 02-25-2011 at 01:47 PM. Reason: Added Code Tags
    Reply With QuoteRegister To Reply
  2. 02-25-2011, 01:58 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Replace Macro is really slow

    Hello SandiM,

    Welcome to the Forum!

    Are you wanting to replace all non breaking spaces in each cell with white spaces ?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 02-25-2011, 02:59 PM #3
    SandiM
    SandiM is offline
    Registered User
    Join Date
    02-25-2011
    Location
    Dallas
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Replace Macro is really slow

    I think so..
    Reply With QuoteRegister To Reply
  4. 02-25-2011, 03:02 PM #4
    watersev
    watersev is offline
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Replace Macro is really slow

    hi, try this out:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-25-2011, 05:05 PM #5
    SandiM
    SandiM is offline
    Registered User
    Join Date
    02-25-2011
    Location
    Dallas
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Replace Macro is really slow

    Hi watersev!!!

    Thank you!!!! You ROCK!!! You just made this particular task a breeze!!!!! ))))

    SandiM
    Reply With QuoteRegister To Reply
  6. 02-25-2011, 05:07 PM #6
    SandiM
    SandiM is offline
    Registered User
    Join Date
    02-25-2011
    Location
    Dallas
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Replace Macro is really slow

    [SOLVED] - I hope this is how you mark this post as complete.
    Reply With QuoteRegister To Reply
  7. 02-25-2011, 05:13 PM #7
    watersev
    watersev is offline
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Replace Macro is really slow

    thanks for feedback, SandiM. Working with arrays is quicker than going cell by cell
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1