+ Reply to Thread
Results 1 to 5 of 5

Find and replace where contents a formula so can't be seen by Find and replace.

  1. 04-26-2015, 01:23 PM #1
    markDuffy
    markDuffy is offline
    Forum Contributor
    Join Date
    03-25-2011
    Location
    London, England
    MS-Off Ver
    office 2021
    Posts
    317

    Find and replace where contents a formula so can't be seen by Find and replace.

    Hi Guys

    Find and replace where contents a formula.
    I have entries in Column H which hare formula so can’t be found by something as simple as find and replace. If you have some ideas then I would be grateful. Unless converting it to values is the only way. I have tried using filter but don’t know how.
    I am uploading two sheets one what I am looking for and the other what I have.
    Mark
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-26-2015, 01:42 PM #2
    HerryMarkowitz
    HerryMarkowitz is offline
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: Find and replace where contents a formula so can't be seen by Find and replace.

    Try...
    Please Login or Register  to view this content.
    Sub DontForgetThese()
     If Your thread includes any code Then Please use code tags...
     If Your thread has been solved Then Please mark as solved...
     If Anybody has helped to you Then Please add reputation...
End Sub
    Reply With QuoteRegister To Reply
  3. 04-26-2015, 01:45 PM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Find and replace where contents a formula so can't be seen by Find and replace.

    You may try something like this.....
    Please Login or Register  to view this content.
    Please find the attached workbook and click on the Button to run the code.
    Attached Files Attached Files
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 04-26-2015, 02:16 PM #4
    markDuffy
    markDuffy is offline
    Forum Contributor
    Join Date
    03-25-2011
    Location
    London, England
    MS-Off Ver
    office 2021
    Posts
    317

    Re: Find and replace where contents a formula so can't be seen by Find and replace.

    Hi Sktneer
    Thank you. it is as you know absolutely fabulous. And for adding the underlining which I was trying to do myself. Thank you again
    Weather in London has been magnificent but now it feels as though winter is coming back.
    Today we had the marathon. Watched it on TV as my partner was a marathon runner. She may take it up again.
    All the best
    Mark
    Reply With QuoteRegister To Reply
  5. 04-26-2015, 02:24 PM #5
    markDuffy
    markDuffy is offline
    Forum Contributor
    Join Date
    03-25-2011
    Location
    London, England
    MS-Off Ver
    office 2021
    Posts
    317

    Re: Find and replace where contents a formula so can't be seen by Find and replace.

    Thanks Harry
    Hope all going well with you in Istanbul. In London we have just had the marathon. And looks like winter is coming back.
    Again thanks
    Mark
    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)

Similar Threads

  1. [SOLVED] VBA Find and Replace Using Cell Contents
    By DMumme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2014, 10:22 AM
  2. Macro- Find the second of two identical rows and find and replace the contents of second
    By cre8787 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2013, 03:48 PM
  3. Find maximum and replace contents by a formula
    By rajeevmenon1975 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-20-2012, 07:37 AM
  4. Find and replace with contents of a cell
    By gettingthere in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2009, 03:24 PM
  5. Find and Replace Hyperlink Contents
    By Dede in forum Excel General
    Replies: 11
    Last Post: 04-28-2005, 08:06 PM

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