Find Or Replace Chr(160 In Excel For Mac

• Points

  110

  Posts

  12

  I am trying to create a VBA script that I can run anytime the task needs done. I need it to find one value within a specific range, and replace it with a forumla.

  
  

  I thought I'd gotten it to work, but it appears it will only run the first time I execute the macro, even if the next time I execute it more values exist that should be replaced.

  
  

  Can you help?

  Smokey Robinson & The Miracles: Smokey Robinson & The Miracles - The Greatest Hits ‎ (LP, Comp) Motown: 530 121-1: Germany: 1992: Sell This Version. 1) Select a file to send by clicking the 'Browse' button. You can then select photos, audio, video, documents or anything else you want to send. The maximum file size is 500 MB. Smokey robinson greatest hits rar.

  
  

  Here is what I have so far. (hyperlink URL has been changed):

  
  

  1. Sub ReplaceX()
  2. Range('P5:AC39').Replace What:='Y', Replacement:='=HYPERLINK('http://www.example.com','X')', LookAt:=xlPart, _
  3. SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
  4. ReplaceFormat:=False
  5. End Sub
  1. Navigation
  2. OzGrid
  3. Forum
  4. Members
  5. Options
  6. Current Location
  This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.

  Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.

Then click Replace to replace the text or Find Next to skip to the next occurrence. To replace all occurrences of the search text without confirmation, click Replace All. When the replace session for the entire document is complete, a dialog box informs you how many replacements were made. Click OK or press Enter to close the dialog box.