+ Reply to Thread
Results 1 to 5 of 5

Find and Replace

  1. #1
    Registered User
    Join Date
    08-18-2014
    Location
    Nongprue, Thailand
    MS-Off Ver
    MS Excel for Mac; Version 16.8; 365 subscription
    Posts
    24

    Find and Replace

    I use Excel for Mac (Version 16.8) with a 365 subscription

    All of a sudden, I cannot use the "Find and Replace" function anymore. The Dialog box does not even come up!

    I used this function also in the following macro (within a recorded macro)

    Columns("O:O").Select
    ExecuteExcel4Macro _
    "FORMULA.REPLACE("","","""",2,1,FALSE,TRUE,,FALSE,FALSE,FALSE,FALSE)"


    but it won't execute it.

    I'm at a loss... Thanky you for your help

    Felix

  2. #2
    Registered User
    Join Date
    02-17-2011
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2016
    Posts
    20

    Re: Find and Replace

    Felix, I can't speak to your Mac, but I have discovered a similar issue on my Windows machine. I would like to do a Find and Replace on a special character (line break). I used to be able to go to Find and Replace, click on the More button and choose the character on which to search. However, now, in Excel 365, Version 1712 (Build 8827.2148 (Click-to-Run), the More button is gone! Is there a work-around for this?

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Find and Replace

    @copperberry

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Find and Replace

    @fak119

    Look at this link for the proper syntax for VBA Replace as it is different from the WS function.

    https://www.techonthenet.com/excel/f...eplace_vba.php

  5. #5
    Registered User
    Join Date
    02-17-2011
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2016
    Posts
    20

    Re: Find and Replace

    Sorry, Alan (and everyone else.) I have created a new thread. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using find replace to first find two double quotes and replace with a single double quote
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-17-2015, 10:13 AM
  2. [SOLVED] Find and replace where contents a formula so can't be seen by Find and replace.
    By markDuffy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2015, 02:24 PM
  3. Replies: 16
    Last Post: 12-02-2014, 03:38 PM
  4. Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  5. [SOLVED] find and replace to not replace characters found as wildcards
    By sabutler4 in forum Excel General
    Replies: 4
    Last Post: 07-03-2013, 06:48 PM
  6. find in excel replace in word: find/replace text in text boxes and headers
    By dean.rogers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2012, 12:40 PM
  7. [SOLVED] find and replace - replace data in rows to separated by commas
    By msdker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2006, 08:10 PM

Tags for this Thread

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