+ Reply to Thread
Results 1 to 2 of 2

speading up a multiple Find and replace Macro

  1. #1
    Registered User
    Join Date
    09-03-2009
    Location
    boston,ma
    MS-Off Ver
    Excel 2003
    Posts
    18

    speading up a multiple Find and replace Macro

    Hey, I'm new to VBA and still learning and greatly appreciate the help!


    I need to find any case of 3."1-200". and 5."1-200". and replace it with "".

    Currently I have it to separately find and replace

    Please Login or Register  to view this content.
    And so on

    Can i write something like 3.*. but only when its up to 3 characters? Thanks!
    Last edited by highwyre237; 09-18-2009 at 01:56 PM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: speading up a multiple Find and replace Macro

    Here is a different approach. Assumes value in A1 and puts result in B1. Not 100% sure it will work 100% but give it a try:
    Please Login or Register  to view this content.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1