Results 1 to 1 of 1

Thread: [Ask]Code VBA filter range from Formula of cell

  1. #1

    [Ask]Code VBA filter range from Formula of cell

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Formula of cell A1: "= Sheet1!A2+Sheet3!A3"
    Formula of cell B1: "= Sum(Sheet1!A5:A10)+Sheet2!$C$7"
    I want a function named FilterRange (arg) with arg is argument address of cell (such as A1, B1).
    Function return array containing ranges that cell has reference to.
    FilterRange(A1) --->array("Sheet1!A2", "Sheet3!A3")
    FilterRange(B1) --->array("Sheet1!A5:A10", "Sheet2!C7")
    Last edited by hochoaivandot; 2012-10-26 at 09:12 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts