• 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. B

    Use VBA to highlight cells with a dependency in another sheet

    Hi Narayan, I just noticed that the RefTreeAnalyser does not work with 64Bit Excel 2010. Have you seen a similar product that works for the 64Bit version?
  2. B

    Use VBA to highlight cells with a dependency in another sheet

    Thanks Hui and Narayank991. Nice to be on board. The only catch with the Trace Dependents button in the Formula Auditing tab (Excel 2010) is that it can only be used on the active cell one at a time and that you end up with arrows all over the place and I have thousands of cells to audit. All I...
  3. B

    Use VBA to highlight cells with a dependency in another sheet

    Hi, I need to write a macro to highlight all cells within a selected range that have a dependency in either the same worksheet or elsewhere in the workbook on another worksheet. I believe this can be achieved by using the navigate arrows (.navigatearrow) however I’m not sure how to put this...
Back
Top