• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    Macro to find & replace text

    Hello everyone, I have two files, Book1 & Book2. Book1 is used for reporting. I have to do find and replace many times to update this workbook. Is it possible to do it with a macro. I will put "text to be find" in Cell A1 of book2 and "text to be replaced" in cell A2 of book2. When I run the...
  2. R

    Links using Indirect function

    Hi, I have created a link to another workbook using indirect function. When such source data file is closed it shows #Ref error. I used manual calculation option but it fails when I refresh the file. Basically, purpose of creating of link using indirect is only that I want to change sheet...
Back
Top